The URL can be used to link to this page

R-2022-044 - 2/10/2022 RESOLUTION NO. R-2022-044 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 Ouarterly Investment Report (or the quarter ending December 31, 2021 for the City of'Round Rock has been submitted to the City Council; and WFIEREAS, the City Council desires to acknowledge the receipt and acceptance of the attached Quarterly Investment Report, Now (herefore BE ITRESOLVED BY THE COUNCIL OF THE CITY OF ROUND ROCK, TEXAS, That the Quarterly Investment Report. attached hereto as Fxhibit, "A" and incorporated herein, is hereby received and accepted. ThC 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 fornially acted upon, all as required by the Open Meetings Act, Chapter 551, Texas Government Code, as amended. RESOLVED this 10th day of 11ebruary, 2022. 11RI, CRAIG&k6 Mayor City Of u ck, Texas ATTU-I'ST: MEAGAN 11PINKS, hy Clerk W 12.2022?.,4962-7152-t5,11 EXHIBIT "A" R�DUNCDRDCCIKTEXAS 'F11NANCE QUARTERLY INVESTMENT REPORT For the Quarter Ended December 31, 2. 21 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. /Signature withheld for security purposes/ /Signature withheld for security purposes/ Chief Financial Officer Deputy Chief Financial Officer /Signature withheld for security purposes/ /Signature withheld for security purposes/ Controller Treasury,Accountant Valley View Consulting, LLC Dated Dischihiler These reports were Compiled using inl6rillation provided by the (:ity, No procedures were perfioritied to test the accuracy or complocticss of this ii-irolinalion. 'I lie market values included in these reports were obu6ned by Valle) Viev Consulting.L.L.C . from sources believed to tic accurille and represent proprietary valmition. Due to market fluctuations Illese levels are not necessaril 0. Yidd C111CUlations are not determined using soindard ,� rcliective of Current liquidation 11111 V, perfin-inance fiormUhIS,are not representative oftoud return yields and do not account Im investment advisorlees. Summary Holdings by Investment Category(Security Sector) December 31,2021 YTM @ Description Cost Book Value Market Value Cash 0.15% $ 19,860,508 $ 19,860,508 Certificates of Deposit 0.39% 259,151,943 259,151,943 Local Government Investment Pool 0.03% 53,116,022 53,116,022 money MarKetAccounts U.3u% Municipal 0.27% 18,368,702 18,318,866 US Agency 0.36% 31,959,364 31,845,175 US Treasury 0.35% 33,790,710 33,608,148 Total/Average 0.32% $ 486,553,998 $ 486 207 12 September 30,2021 YTM @ Description Cost Book Value Market Value Cash 0.14% $ 20,388,226 $ 20,368,226 Certificates of Deposit 0.53% 295,898,976 295,898,976 Local Government Investment Pool 0.03% 27,503,126 27,503,126 Money Market Accounts 0.28% 1 75,253,290 75,253,290 Municipal 0.32% 13,344,197 13,344,663 US Agency 0.17% 13,991,601 13,986,417 Total/Average 0.42% $ 464 520,518 $ 464,613,"S Average Yield Current Fiscal Year- Quarter(1) to-Date(2) Total Portfolio 0.32% 0.32% TexPool Yield 0.04% 0.04% Rolling Three Mo.Treas.Yield 0.06% 0.06% Rolling Six Mo.Treas.Yield 0.08% 0.08% Rolling 1 Yr.Treas.Yield 0.11% 0.11% Rolling 2 Yr.Treas.Yield 0.32% 0.32% Investment Income(3) Interest Income(Approximate) $ 347,596 $ 347,596 WAM at 12/31/2021 Policy WAM Max Total Portfolio 238 days 540 days Pooled Funds 254 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 12/31/2021 The Federal Open Market Committee(FOMC)maintained the Fed Funds target range at 0.001/6 to 0.25%(Effective Fed Funds are trading<0.10%). The FOMC began reducing monthly SeCUuty purchases during Nov 2021 and then increased the pace at the December meeting. Projections for target range increases shortened to late spring or early suirnmer 2022 Third Quarter GDP posted+2 %(Final) December employment reflected U-2 dropping to 3.9%,and Non-Farm Payrofl adding 199k net new jobs(Three Month Average NFP=365). Crude oil reversed recent declines,and bounced back to+/-$75 per barrel The Stock Markets reached new highs Many domestic economic indicators remain positive. The Build Back Better legislation stalled in the Senate. The Debt Ceiling was increased to$31+trillion,easing any near-term funding pressures. Inflation remained well over the FOMC 2%target and does not appear positioned to decline in the near term. The Yield Curve shifted higher primarily six months and longer. 1.60 Treasury Yield Curves 5,250 S&P 500 5,000 4,750 .............. 1 'OOOMON oom 4,500 1,20 �qgoqvfl 4,250 4000 3750 ................... 1,00 3,500 3�250 0,80 .......... 3,000 d 2,750 ... .. .. ........... 2500 0.60 .................. 2,250 ........... 40OW0011100411000 ............W, 7u ill 2,000, 0,40 dom ..........----------- ................ 1,760 Wool doll dop 1,500 - 1,250 -– ..................... 0.20 ....... ...................... .. ............ U00 ........ AW am 750 ..0.00 ..... 500- ...... .. ........... 250 —ci ----- 5�_ 0 - 40 Nb �IA Nc� N ��rwwua�q�Bmbeti r 31,2020 mber 30,2021 December 31,im ....... .........®ate 6.00 US Treasury Historical Yields-Since 2006 3 50 US Treasury Historical Yields-Since Nov 201:15 5.50 ............. 5M 3,00 -AA 4.50 4.00 0 3.50 2 00 ............. .......................— At 3,00 2.50 1.50 do ............... 2,00 1.50 1.00 _00 1.00 of 050 ............................. 0,50 .......... umiw 0 00 A OrGO — NIa 1it 0 Nq lip jp 2� ae ID �01 10 'IN , Six MoMb T-Bill tw,o'Y–ear,T'-'Note bra Year.T Note Six M cint1hT-13,01. !T�Two,Year-T-Note Teri Year T-Note J Valley View Gensulirling,L.L.C. 2 Holdings, by Investment Category Decernber-31 2021 .... ......... .._. Pga1e . ob$»ervla0 Reserve-- i/r ,o ftdrrr r, TStaf � i Frtrtfo4rFunds rr Fonds . r / ; a; , Book Value %of Portfolio Soak Value / of Portfolio Book Value ! of Prrtfollu Cash 19,852,167 4% $ 8,342 0% S a% 0% 19,860,508 4% Certificates of Deposit 222,522,881 46% – 0"% –, 0% 36,629,0'62 81/0 259„151,943 53% Investment Pools 41,990,999 9'% 7„277,781 1`A✓a 261,791 0% 3,585,452 1% 53,116022 I'l% MoneyMark etRCCounts 56,289„406 12% 1,292,712 0% 858,318 0% 11,866,314 2% 70,306,749 14% Municipal 18,36$702 4% _ 0% – 0% – 0% 18 368,702 4%, US Agency 31,959,364 7% 0% 0%9 – 0% 31 959 364 7/6 US Treasury 33,790,710 7% -- 0% 0% – 0% 33 790,710 7% ;P Ila y 1 ° ,". $424,774,228 87% r%�y 1�a&33a�,r,..,, �°av,_.::r,r $ 1,1 0,108 0Aa !!� '��$ "1 r%;'i,r!1� ttr%�„ $480in5S8'.�JB tk70°Yn Portfolio Balances (IVIiIIIons) Order of LigUidity $500 $450rriiir ///Y Casi7 rrrrrr�%., $400 or r 0 Local Government $355 Investment Pool $300 .. .,..... _ ...._, ��i 0sir/mi .....,. Money Market AcCOUnt c, $255 ��,/% _ .._®._ _ _, – iMUS'Treasury $200 01 US Agency $155 $100 DMumcipal $50 _ – — - InCerlificates of Deposit $a _. Pooled Funds DS Funds DSR Funds CP&SP Funds Total Portfolio 12/31/2021 12131/2021 12131/2021 1213112021 12/3112021' 3 City of Round Rack Valley View ConSUlling, L.L.C. Investment Holdings by Investment Category Quarterly Transactions By Investment Category December 31, 2021 December 31,2021 %of Portfolio Net Cash Equivalent Description Book Value Portfolio Limitation Description Buys Sells Maturities Calls Interest DeposltlffiithdrawalM Cash $ 19,864,508 41% 100% Cash $ $ — $ S — $ (527,718) Investment Pools 53,116,022 10.90 100% Investment Pools 2,569 25,612,897 Mone y Market Accounts 70,,346,749 144% 75% Money Markets Accounts — 53,459 (4,946,541) Certificates of Deposit 259,151,943 53.3% 85% Cerfificates of Deposit 18.257,553 55,004,586 357,547 Commercial Paper — 0,0% 110%/5,/,D Gornmer6al Paper — Municipal 18,368,702 3.8% 35%15% lmunucipal 5,,113,850 26,228 — USA ency 31,959,364 6.6% Combined 'US Agency 17,965,065 3,125 US Freasury 33,790,710 6.9% 75%, US Treasury 15,793,026 — — Total/Average $ 486,553,998 10006 PASSED Totals $ 57,129,493 1 $ $ 55,004,586 $ 442,927 $ 20,138,637 Portfolio Balances (Millions), Money Market Accounts Portfolio Composition Order of Liquidity 14,4% December 31,2021 $500 $450 .. ............... L encash Investment Pool $40010.9%, 0 Loca I Government $350 Investment Pool $300 jG Money Market Account Cash $250 4 1'D/o 0 US Treasury $200 US Treasury $150 0 US Agency 6.9% $100 Wunicipall % Certificates of $r 50 ...... Depos4 $0 aliCeriftUSates of Deposit 66%Agenc Mummpal ZP 4V 4V 11P 38% 4 City of Round Rock Valley View Consulting, L.L.C. Portfolio Balances By Fund (Millions) $500 I $450 , i $400 ®CapAal Propect& 5350 Special Purpose Funds *Debt Service Reserve Funds $25[7 $240 *Debt Service Funds $150 51oo 0 Pooled Fund's $50 5 `7r� '"V� ,y4 ,•�q "V� �Q X45 ,�Q, ,,�t'a ,�41 rib '`L� ,y4, ,.�s3 „�'C5 r�fi+ ,�CSx'69 ,�,Cr �4y rye �Q ''Irq r�4a ,.�Ca ,QCs 5 City of Round Dock Valley View C onsult ng,L.L.C. City of Round Rock Pooled Funds Performance 2.60 ----------- 2.50 .................................. . ............... -------------- 2.40 ............... ....................--............... 230 ------------------- ir 2.20 ...................... 2.10 ............. ................................... 2.00 . ....... ---------- .................. ...........- ................................ .................................... 1.90 -------- 1,70 .. . .... _. . 1,, ..... ................. ......... 1,60 1.50 .......... ............................... 1.40 --------- -—------------ -------------- ................................ -------- ,arC 1.30 . . ...... ------- .. .. ............... 1.20 CL 1.10 -------- 1.00 ..................... ..........- 0.90 .......... 0.80 ......---- 0.70 0.60 400 vao-liq ................................ 611100:;p % .......... 0.50 . ............ ...... - ----------------------------------------- —--- ----------------- ...................................................... 0A0 ONKA ii . - 030 - --- -----------— . ......................... ........ ......... 0.20 ........ .... . ------ ---------- -------------- \............... 0.10 0.00 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. Holdings by Allocation and Portfolio (Fund) December 3,1, 2021 Issuer Coupon Credit Rating Settlement Face ,mount! Days to YT Book Value Market Market Value Maturity Date M @ I Rate Date Stnares Price Maturity I Book Fund O00-Pooled Investments NexBank 0,40% 1-1/29/201,6 S 36,128,965 S 36,1128,965 100.00 5 36,128,965 N/A '1 0,40% IexasDAILY 0.02% AAArn 6/1/2021 1,799,178 1,799,178 100.00 1,799,178 NfA 1 0.02%, Texas Capital Bank 0.15% 7/1/2021 9,978,,074 9,978,074 100.00 9,978,074 N/A 1 015% TexasDAILY,Selecl-,--- Dal lafa AAAm, ...... ... .12/3/2021 1,000,194 100,00 1,000,1,94 N/A 1 0,I1°% ,Veritex Community Bank 0.10% 9/112020 175,945 175,945 100.00 175,946 N/A 1 0.10% R Bank 0.25% 11/29/2021 2,000,301 2,000,301 100,00 2,000,3011 N/A 1 025% ipmor2an Chase 0.15% 9/30/2015 19,852,167 19,852,167 100.00 19,852,167 N/A 1 0A5% TexSTAR 0.03% AAAm 9/30/2015 200,533 200,533 100.00 200,533 NIA 'I 0.03% TexPool 0.03% AAAm 9/30/2015 38,192,515 38,192,515 1001.00 38,192,515 NIA 1 0,03% ProsLerity Bank 0.15% 9/14/2021 6,005,078 6,005,078 100.00 6,005,078 NIA 1 0.115% TexasDAILY 0.02% AAAm 9/30/2015 798,578 798,578 100,00 798,578 N/A 1 002% Prospetity Bank 0.15% 9/1412021 2,001,042 2,001,042 100.00 2,001,042 N/A 1 0A5% Bank OZK 1.70% 1/2812020 8,265,088 8,265,088 100.00 8,265,088 '112412022 24 1.70% R Bank 1.75% 1/27/2020 2,062,221 2,062,221 100,00 2,062,2211 1127/2022 27 1.75% Allegiance Bank 1.59% 2/10/2020 5,140,,652 5,140,652 100,00 5,140,652 2/10/2022 41 1.59% Goose Creek ISD 5.00% Aaa/-/AAA 11/17/2020 400,000 402,341 100.51 402,048 2/15/2022 46 0.33% East West Bank 1.54% 2/18/2020 5,146,178 5,146,178 100.00 5,146,178 2118/2022 -49 1.54% �East West Bank 0.17% 2/1912021 111,101,109 11,101,109 100.00 11,101,109 2121/2022 52 0A7% �FORT BEND COUNTY-REF 5,00% Aal/-/AA+ 6/17/2020 250,000 251,638 100.76 251,898 3/1/2022 60 0.98% 'Allegiance Bank 0,40% 6/17/2020 10,059,985 10,059,985 100,00 10,059,985 3/18/2022 77 0A0% 111deeendent Bank 0.40% 1/11/2021 20,059,895 20,059,895 100-00 20,059,895 4/1112022 101 0.40% �Veritex Community Bank 0.20% 215f2021 3,004,490 3,004,490 100.00 3,004,490 5/5/2022 125 01.20% Prosperity Bank 0.20% 2/12/2021 4,006,646 4,006,646 100.00 4,006,646 5/12/2022 132 0.20% 1 Independent Bank 030% 5/1912021 6,009,077 6,009,077 100.00 6,009,077 5/19/2022 139 0.30% Allegiance Bank 0.45% 6/17/2020 12,081,005 12,081,005 100.00 12,081,005 6/17/2022 '168 0.45% Bank OZK 0.501% 71912020 10,071,196 1,0,071,196 100.00 10,071,196, 7/11/2022 192 0.501% Veritex Community Batik 0.24% 2/5/2021 3,005,388 3,005,388 100.00 3,005,388 1512022 217 0.24% Prosperity Bank 0200/o 2/1212021 3,004,985 3,004,985 100.00 3,004,985 8/12/2022 224 0,20% Bexar Co Txb Ref 033% A21AA/A- 9/23/2021 560,000 560,000 99.83 559,054 8115/2022 227 0,33% Arlinqton TX HGR EDU 0.50% -/AAA/- 4128/2021 500,000 500,000 99.97 499,830 811512022 227 0,.50% Denton ISD 0.00% -/AAA/AAA 12117/2020 500,000 498,569 99.77 498,845 8115/2022 2271 0A6% 1 City of Bryan TX 0.45% -IAA/- 11/1912020 500,000 500,000 99.99 499,945 811512022 2271 0A5% 1 C4y of Austin G5- 027% Aa 1/AAA/AA+ 1016/2020 700,000 700,000 99.98 699,832 91112022 244 0,27% Prosperity Bank 0.20% 6/1/2021 3,003,009 3,003,009 100,00 3,003,009 9/112022 2441 010% Veritex Community Bank 0.18% 3/5/2021 8,010,854 8,010,854 100.00 8,010,854 9/5/2022 248 F 0.18% State of Texas 1.61% AaatAAA(- 311912021 3.250,000 3,285,572 100.92 3,279,965 10/1/2022 274 015% State of Texas 2.52% Aaa/AAA/- 10/14/2021 5,000,000 5,088,622 101.59 5,079,400 10/1/2022 274 015% Prosperity Bank 0,40% 10/15/2020 6,028,058 6,028,058 100.00 6,028,058 10117/2022 290 0.40% Verqex Community Bank 026% 2/5/2021 3,005,838 3,005,838 100.00 3,005,838 11/412022 308 0.26% 1 Prosperity Bank 0.20% 2/12/20121 3,004,985 3,004,985 100.00 3,004,985 11/14/2022 318 020% 1 R Bank 0A8% 11/24/2021 4000,000 4,000,000 100.00 4,000,000 11/23/2022 327 048% Bank OZK 0.28% '12/7/2020 5,014,068 5,014,068 100.00 1 5,014,068 12/7/2022 341 0.28% lProsperfty Bank 0.20% 61912021 10,010,032 10,010,032 100.00 10,010,032 12/9/2022 343 0.20% Vedtex CortirTlUnity Bank 028% 1/612021 4,008,383 4.008,383 100.00 4,008,38-3 1/6/2023 371 0.28% R Bank 0.57% 71612021 1,001,443 1,001,443 100.00 1,001,443 1/6/2023 371 0.57% Vertex Community Bank 0.30% 215/2021 4,,409,880 4,409,880 100.00 4,409,880 2/612023 402 0.30% FFCB 0.16% Aaa/AA+IAAA 11/2212021 5,000,000 4,994,526 99.60 4,979,927 2/10/2023 4061 0,2 6 OXO I Eagle Pass Texas 4L0% -1AA-1- 6/7/2021 645,000 673,50,1 1, 104.30 672,709± 3/1/2023 11 4251 0.20% 7 City of Round Rock Valley View Consulting, L.L.C. Hold'ings by Allocation and Portfolio (Fund) December 31, 2021 Issuer Coupon Credit Rating Settlement Face Amountf Book Vaiue Market Market Value Maturity Date Days to YTM @ Rate Date Shares, Price Maturity Book Prosperity Batik 0.25% 31512021 10,018,851 10,018,857 100.00 10,018,851 3/6/2023 430 0.25% Bank OZK 0.26% 3/812021 2,534,064 2,534,064 100,00 2,534,064 3/8/2023 432 0.26% FFCB 0.13% Aaa/AA+/AAA 3Y2612021 9,000,000 8,997,233 99,53 8,957,428 3/2312023 447 015% Prosperity Batik 0.20% 4/12/2021 5,006,689 5,006,689 100.00 51006,689 4/1212023 467 0,20% FFCB 0.13% Aaa/AA+/AAA 4/13/2021 5,000,000 4,,995,769 99.46 4,973,,246 4/1312023 468 0.19% Prospertly Bank 0.201 511'91202!1 10,011,732 10,011,732 100,00 10,011,732 5/19/2023 504 0,20% Veritex Community Batik 0.20% 6/112021 20,020,060 20,020.060 100.00 20,020,060 6/112023 517 0.20% Bank OZK 010% 6/9/2021 8,008,065 8,008,065 100.00 8,008,065 619/2023 525 0.20% R Bank 0.70% 7/6/2021 1,001,771 1,001,771 100.00 1,001,771 7Y612023 552 070% Treasu[y 1.25% Aaa/AAA/AAA 7/712021 8,000,000 8,129,615 101,00 8,080,304 7/3112023 577 0.22% Veritex Community Bank 0.25% 7/30/2021 7,004,411 7,004,411 100.00 7,004,411 7/31/2023 5771 U5% Dallas 1501 4.00% Aaa[AAAIAAA 4122/2021 4,,195,000 4,448,458 105,42 4,422,159 8/15/2023 592 0.26% Arlington TX HGR EQU 0.63% -/AAA/- 4/2812021 1,460,000 1,460,000 99.53 1,453,182 8/15/2023 592 063% Veritex.Community Batik 0.25% 8/23/2021 4,402,773 4,402,773 100.00 4,402,773 8123/2023 600 025% Treasury 0.25% Aaa/AAA/AAA 9/30/2021 10,000,000 9,991,977 99.30 9,929,865 9/3012023 638 0,30% Treasury 2.88% Aaa/AAA/AAA 1112212021 10,000,000 10,437,392 103.93 10,393,286 10131/2023 669 0 47% FHLB 0,50% AaalAA+/- 11/12/2021 5,000,000 4,997,855 99.55 4,977,639 11/9/2023678 0,52% "TreaSUry 2.88% Aaa/AAAJAAA 11110/2021 5,000,,000 5,231,726 104,09 5,204,603 11/30/2023 6991 0A4% FHLB 0,50% Aaa/AA+/- 12/71202,1 8,,000,000 7,973,981 99A6 7,956,935 121812023 7071 0.6711% Sub Total I Average O.52% 423,615,452 424,774,228 100A5 424,427,641 2541 0.34% Fund 170-Interest&Sinking GO Bonds TexasDAILY 0,02% AAArn 11 4130/2016 I 191,061 1 191,661 1 -16-0-.601-- 191,061 1 - NiA I 11 0.02% 'NexBank 0.40% 17 1 212712011 1,292,7121 1 1 N2,712 I ..--100.00 1,292,712 N/A 11 0.40% TexPoof 01.03% AAAm 9/30/2015 1 3,159,185 11 3,159,185 100,00 3,159,185 N/A 1 0.031% Sub Total f Average 0.13% 4,642,957 1 4,642,957 i IWOO 4,642,957 11 0.13% Fund 210 Interest&Sinking Debt Service Jpmof2an,Chase 015%, 9/30/2015 8,342 8,342 100.00 8,342 N/A 11 0.15% Sub Total/Average 0,15% 8,342 8,342 100.00 8,342 11 0,15% Fund 462-2017 Bond Fund TexPooll 0.03% AAAni 5/3012017 1 3132tl 1238 1 --3,3-31,236-1 100m 1 3,331,2381 N/A 1 1 0. 3% NexBank 0.40% 3/30/2020 1,611,300 0 East West Bank 026% 12128t2021 6,00G,171 6,000,171 100.00 6,000,171 6/28/2022 1791 0.26% Sub Total I Average -0.21% 10,942,710 10,942,710 100.00 10,942,710 9911 0,21% Fund 465-Road CO Bond Fund Texas Ca /tai Bank 0.15% 6/1/2021 10,039,357 10,039,357 100.00 10,039,357 N/A 1 0.15% TexPool 0.03% AAArn 9/1/20,20 32,581 32,081 100.00 32,081 N/A 1 0.03% East West Bank 0.18"/7 12/9/2021 8,000,907 8,000,907 100.00 8,000,907 6/9/2022 160 0.18% Prosperq Bank 020% 7/6/2021 10,,008,386 10,008,386 100.00 10,008,386 7/612022 187 0.201% Prosperity Bank 0.20% 6/1/2021 7,007,022 7,007,022 100,00 7,007,022 911/2022 244 0,20% Veritex Corrinnutifty Bank 0.30% 2/5/2021 5,612,575 5,612,575 100.00 5,612,575 2/6/2023 402 0.30% �Sub Total I Average 1 0.20% 1 40,700,329 40,700,329 100.00 40,700,329 1751 0,201% �Fund 591-Reserves Fund �TexPool 0.03% AAArn 9/30/2015 8,723 8,723 100.00 8,723 N/A I om% 1NexBank 0.40% 4/2912019 858,318 858,318 100.00 858,,3181 N/A I 11 0.40% �Sub Total/Av rage 0.40% ...... 867,041 867,041 1 1100.00 867,041 1 11 0.406i1a 8 City of Round'Rock Vatley View ConSU16t1g,L.L.C. Holdings by Allocation and Portfolio (Fund) December 31, 2021 I Coupon Settlement Face Amount/ Market Days to YTul issuer Credit Rating Book Value @ Rate I i Date Shares Price Market Value Maturity Date Maturity Book Fund 602-interest&Sinking Revenue Bonds TexPool 0.03% AAArn 9130/2015 3,927,536 3,927,536 1 100.GO 3,927,536 N/A 1 0.03% Sub Total I Average 0.03% 3,927,536 3,927,536 1010.001 3,927,536 1 1 0X3% Fund 605-Kalahari Debt Service Reserve TexPool O03% XXAFn 030019 255:669 1 253:668 100 00253,068 1 NIA 11 0.03% Sub Total I Average 1 0,03% 263,068 253,068 1100.001 253,068 1 11 0.03% Fund$63-Drainage Utility Revenue Bond NexBank OA0% 1 8/30/2020 215,657 215,657 _100.00 215,657 N/A 11 OA0% TexPoW 0,03% AAArn 10/31/2015 222,132 222,132 100-00 222,132 NIA 1 0,03% �sub Total I Average 0.21% 437,789 437,789 100.00 437,789 1 0.21% Total I Average 1 0.48% 1 1 $ 485,395,222 1"$ 486,553,998 100.17 $ 486,207,412 238 0,32% 9 Cily of Round Rock Valley View Consulting, L.L.C. Book Value Comparison December 31, 2021 Issuer Coupon Settlement Maturity Beginning Book Total Buys/ Total Sells/ change in Book Rate Date Date Value Increases I Decreases Value Value Fund 000-Pooled Investments JPMorqan Chase N/A 9130/2015 N/A S 20,145,855 $ 74,772 $ 368,460 19 652,167 $ (293,688) TexPocl NIA 9/30/2015 N/A 13,349,268 29,385,350 4,542,103 38,192,515 24,843,247 TexSTAR N/A 9/30/2015 N/A 2100,527 6 - 200,533 6 TexasIDAILY N/A 9/30/2015 N/A 5,048.440 241 4,2'50,102 798'578 4,249,861) TexasDAILY N/A 6/1/2021 N/A 1,799.103 75 1,799,178 75 1'exasDAlLY Select NIA 1 PJ3/2021 NIA - 1,000,194 "1,000194 1,000,194 NexBank N/A 11/29/2016 NIA 36,0911,817 37,149 36,128,965 37,149 R:lBank N/A 11/2912021 NIA - 2,000,301 2,000,301 2,000,301 Veritex Community Bank N/A 9/112020 N/A 175,902 43 175,945 43 Texas Capital Bank N/A 7/1/2021 N/A 7,724,273 2,253,801 - 9,978,074 2,253,801 ProsperiLy Bank N/A 9114/2021 N/A 13,000,855 5,004,224 12,000,000 6,005,078 (6,995,776) Prosperity Bank N/A 9/14/2021 N/A 2,000,132 910 - 2,001,042 910 Veritex Community Bank 1.71% 10/3/2019 10/4/2021 10,303,235 - 10,303,235 , - (10,303,235) 'East West Bank 1.65% 1127/2020 1012712021 6,168,587 - 6,168,587 (6,168,587) East West Bank 1 54% 2/18/2020 11119/2021 6,151,499 8,051_ 6,159,541 (6,,151,490 East West Bank 1.64% 11/2;2/2`019 11/2212021 5„154„89(17,185 5,162,075 (5,1 4,896 independent Bank 0,40% 1217/2020 12/7/2021 8,024,046 -- 8,024,046 (8�,024,046) Veritex COMMUnity Bank 167% 12120120,19 1212012021 5,148,261 - 5,148,261 �5,148,'26"1) Bank OZK 170% 1/2812020 1/24/2022 8230,136 34,952 - 8,265,088 34.952 R Bank 1.75'% 112'7/2020 1127/2022 2,053,145 9,076 2,062,221 9,0761 Ahegiance Bank 'I.59,% 2/10/2020 2/10/2022 5,120,132 20,520 5,140,652 20,520 5.00% 1111712020 2/15/2022 407,024 - Goose Creek ISD 402,341 4,683�1 East West Bank 1.54% 2/18/2020 2118/2022 5,126,242 19,937 5,146,178 19,937 East West Bank 017% 2119/2021 2/21/2022 11 096,354 4,756 1 11101,109 41756 FORT BEND CCLJNTTREF 500% 6/17/2020 3/1/2022 254,150 - 251,638 (2,512) TITegrance Bank 0,40% 6/1712020 3/18/2022 10,049,963 , 10,022 10,059985 10,022,� Independent Bank 040% 1111 02021 4/11/2022 20,039691 20.204 20,059,895 20,204 Veritex CornmunitX Bank 020% 2/5/2021 5/512022 3,002,976 1,514 3,004,,490 1,5114 Pros Brit Bank_ 0.20% 2/12/2021 5/12/2022 4,004,649 1,997 4,006,646 1,997 Independent Bank 0,30% 5/1912021 511912022 6,004,537 4,540 6,009,077 4,540 Aliegiance Bank 045% 6117/2020 6/17/2022 12,067,466 13,539 12,081,005 13,539 Bank OZK 0:50% 719/2020 7/1112022 10,058,652 12,544 11,071,196 12',544 Veritex Community Bank 0.24% 2/5/2021 8/5/2022 3,003,571 1,817. 3,005,388 1,817 Pros Brit Bank 0.20% 2112/2021 8/12/2022 :3,'003,4871 1,498 3,004,985 1,498 ArlinUton TX,HGREDU 0.50% 4/28/2021 8/15/2022 500,000 - - 500,000 1 - Bexar Cc Txb Ref 0,33% 9123/2021 8/15/2022 560,000 - - 560,0001 City of Bryan TX 0.45% 11119/2020 8/1512022 500,000 - - 500,000 Denton iSD 0.00'/b- 12/17/2020 8115/2022 497,989 - - 498,569, 580 City of Austin GO 1.27% 10/6/2020 9/1/2022 700,000 - - 700,000 Prosperity Bank 0.20% 611/2021 9/112022 3,001,513 1,497 - 3,003,019 1,497 Veritex Community Bank 018% 3/5/2021 915/2022 8,007,261 3,593 8,010,854 3,593. State of Texas 2.52% 10114/20211 1011/2022 - 5,113,850 - 5,088,622 1 5,088,62 State of Texas 1.61% 3/19/2021 101I12022 3,297,516 - - 3,285,572 (1 1,944� Prosperity Bank 4.40"'/$ 10115/2020 10117/2022 6,022,050 6,008 - 6,028,058 6,008 Veritex Community Bank 0,26% 2/512021 11/412022 3,002,869 1,969 - 3,005,838 1,969 Prosperity Bank 0.20% 2/12/2021 11/14/2022 3,003,487 1,498 - 3,004,985 1,498 A Bank 4A8% 11/24/2021 11123/2022 - 4,000,000 4,000,000 4,000,000 Bank OZK 0,28% 12f712020 12/712022 _5,010,557 3,511 5,014,068 3,511 Proseenty Bank 0,20% 6/9/2021 12/9/2022 10,005,042 4,990_ 10,010,032 4,990 Veritex Community Bank 0.28% 1/612021 1/612023 4,005,556 2,827 4,008,383 2,827 R Bank 0.57% 7/6/2021 116/2023 1.000,000 1,443 1,001,443 1,443 lVeritex Community Bank 0.310%_ 2/512021 2/6/2023 4,406,548 3.332 4,409,880 3,332 10 City of Round Rock Vailey View Consulting, L.L.C. Book Value Comparison December 31, 2021 Issuer Coupon Settlement Maturity Beginning Book Total Buys/ Total Sells/ Ending Book Change in Book Rate Elate Bate Value increases Decreases Value Value FFC13 0,16% /112212021 2/1012023 4,994.267 - 4,994,526 4,994,526 Eaole Pass Texas 4.00 4b 61H2021 3/112923 679,671 - -- 673.501 (6.112 Pros Brit y Bank 0.25': 3,512021 31612023 M012,609 6.242 - 10.018,851 6.242 Bank 402)1 tt.26% 318/202/ 3/312023 2.532,416 1,648 - 2,534,064 1,646 FFCB C 13% 3/26/2021 312312023 8.996.664 - - 8.997,233 569 Prosperity Bank 0.20:/ 4/1212021 4/1212023 5,004.193 2.496 - 5,006,689 2.496 /=FCB 0.13% 411312021 4/1312423 4,994,937. - - 4,995,765 832 'Prosperity Bank 020% 511912021 5/1912023 10.006,741 4,990 - 10,011.732 4.990 Veritex Community Bank 020% 61112021 61112023 20,010,082 9,978 201.020.060 9,978 Bank OZK 020% 61912021 6!912023 8,004,054 4,012 - 8.008.065 4.012 R Bank 070% 716,/202; 7/672023 1.000.000 41,7 71 - 1,t001,771 1 771 Treasury 125% 71712021 713"112023 8,150,281 - - 8.129.615 Veritex Community Bank 0.25;'4 713012021 ;131{2023 7,000.000 4.411 - 7.004.411 4.411 Arlington TX HGR EDU 0.63' 4128/2021 8/1512023 1,460.000 - 1.460,000 Dallas ISD 4.00% 4122/2021 811512023 4.487.847 - - 4,448.458 (39.389) Veritex Community Bank 0.25% 8/2312021 812312023 4,400.000 2,773 - 4,A02,773 2,773 _ Treasury0,25% 9/3012021 91301202,E 9.990,820 - - 9,991.977 1.157 Treasury 2.88% 11/22/2021 10/31/2023 - 10.480,373 - 10,437392 10437.392 FHLB 050% 1111212021 11/912023 - 4997,700 - 4.997.855 4,997,855 Treasa 2,88% 11110%24121 11/3012023 - 5.312,653 - 6.231.7265.231.726 FHLB 0,50% /2112021 1218121123 - 7.973,098 - 7.973.981 _ 7,973,981 Sub Total/Average Fund 000 Pooled Investments 404,260,556 82,870,945 62,126,410 424,774,228 243.513,671 Fend 170-Interest&Sinking GO Bonds TexPool NIR 913012015 NCA 216,196 2,942,989 - 3,159,185 2,942.989 Te-xasDAILYY N/A 4/30/2016 N/A 505.089 9 314.037 151,061 (314,028) NexBank NIA 2127/2017 NIA 1.291 409 1.303 - 1,292.712 1,303 - Sub Total/Average Fund 170 Interest&Sinking GO Bonds 2,012,694 2,944,300 314,037 4,642,957 2,630,263 Fund 210-Interest&Sinking Debt Service .3PMor an Chase NIA 913012015 NIA 242,371 - 234.030 8,342—r-- (234,030? Sub Total/Average Fund 210-Interest&Sinking[debt Service 242,371_1 234,0301 8,342 234,4330 Fund 462-2017 Bund Fund TexPool NIA 513012017 N/A 3,315.247 15.991 - 3.331.238 15.991 NexBank NIR 313012020 NIR 1.609.677 1,624 - 1,611,300 1,624 East West Bank 026% 1272112020 12/21/2021 6.012.150 2.613 6.014,763 - (6,012,150 East Wes,Bank 026% 12128:202' 6/2812022 - 6.000.171 6.000,171 6,000,171 Sub Total/Average Fund 462-2017 Bond Fund 10,937,074 6,1320,399 6,014,763 14,942,7101 5,635 Fund 465-Road CO Bond Fund TexPool NCA 911/2020 NIA 439 32,081 439 32..051 31,643 Texas Capital Bank. NIA 61112021 N/A 12.285.592 4.081 2.250,316 14,039.357 2.246.235) independent Bank 040% 121€12020 12/7,12021 8,024,078 - 8.024,078 - (8,024-078) East West Bank 0,18% 121912021 6/9/2022 - 8,000,907 - 8.000.907 8,000,907 Prosperity Bank 0.20% 716/24321 7/6/2022 10.003.398 4.989 - 10,008,386 4,989 Prose2rity Bank 0.20% 6/112021 9/1/2022 7,003.529 3 493 7,007 022 3 493 Veritex Community Bank 0,30% 21512021 21612023 5.608.334 4.241 - 5,612.575 4.241 Sub Total/Average Fund 465-Road CO,Bond Fund 1 42,925,369 L___8.049,792i 143,274,832 j 44,700,329 1 (2,225,040) Fund 591 Reserves Fund TexPool N/A 9/30/2015 NIA 8,722 1 - 8,723 1 NexBank NIA 412912019 NIA 857.453 965 - 856.318 865 Sub Total/Average Fund 591-Reserves Fund 866,175 866 867,441 866 City of Round Rock. Valley View Consulting, L.LC. Bo'ok Value Comparison December 31, 2021 Co S Issuer upon Settlement Maturity BeginnIng Book Total Sells/ Ending Book change iin Book Rate Date Date Value increases Decreases Value Value Fund 602-Interest&Sinking Revenue Bonds TexPool 9/30/2015 N/A 2,343,605 1,583,931 1 3,927,536 1,583,931 Sub TotallAver,age Fund 602-interest&Sinking Revenue Bonds 2,343,605 1,583,931 3,927 536 1,583,931 Fund 605-Kalahari Debt Service Reserve TexPool N/A 8/3012019 N/A 253,044 253,668 t 24 Sub Total/Averaue Fund 605-Kalahari Debt Service Reserve 253,,044 24 253,068 24 Fund 863-Drainage Utflity Revenue Bond TexPool N/A 1013112015 NIA 463,446 40, 241,353 222,13- 241,314 NexBank N/A 8/30/2020 N/A 216,183 218 744 215,657 526� Sub Totall/Average Fund 863-Drainage Utility Revenue Bond 679,629 257 242,097 437,789�. (241,840) Total I Average $ 46,4,5200618 $ 101,469,713, $ 79,206,1169 $ 486,553,998 $ 22,033,481_ 12 City of Round Rock Valley View ConSUIting,L L C Market Value Comparison December 31, 2021 Issuer Coupon Settlement Maturity Beginning Total Buys/ Total Sellsl Ending Market Change In Rate Date Date Market Value lncreases Decreases Value Market Value Fund 000-Pooled Investments JPMor2an Chase N/A 9/3012015 NIA $ 20,145,855 S 74,772 $ 368,460 $ 19,852,167 TexPool N/A 9/30/2015 NIA 13,349,,268 29,3851350 4,542,103 38,192,515. TexSTAR N/A 9/30/2015 N/A 200,527 6 - 200,533 1"exasDAILY N/A 9/30/2015 N/A 5,048,440 241 4,250,102 798,,578 'TexasDAILY NIA 61'1/2021 NIA 1,799,103 75 j 1,799,178 1TexasDAILY Select NIA 12/312021 N/A 1,000,194 1,000,194 �Nex6ank N/A 11/29/2016 N/A 36,09:1,817 37,149 1 36,128„965 IR Bank NIA 11/29/2021 N/A - 2,0010,3012,000,301 Veritex Community Bank N/A 911/2020 NIA 175,902 43 175,945 Texas Capital Bank �-NIA 711/2021 N/A 7,724,273 2,253,801 - 7 9,978,074 Prosperity Bank j NIA 9/14/2021 NIA 13,000,855 5,004,224 12,000,000 1 6,005,078 Prosperity Bank N/A 9/14/2021 N/A 2,000,132 910 2,001„042 Veritex Community Bank 1 71% 10/312019 1014/2021 10,303,235 - 110,303 235 East West Batik 1.6510/" 1/27/2020 10/27/2021 6,,168,587 - 6,168,587 East West Bank 154% 2118/2020 11119/2021 6.151490 8,051 i 6,159,541 Tast West Batik 1 641% 11122/2019, 11/22/'2021 5,154,890 7,185 5,162,075 Independent Bank QAOI/o 12/7/2020_ 12/7/2021 8,024,046 - 8,024,046 Vertex Community Bank 167% 12/20/2019 12120/2021 5,148,261 - 5,148,261 Bank OZK 1.70'7 1/28/2020 1/24/2022 8,230,136 34,952 - 8,265,088 �R Bank 1,75% 1/2712020 1/27/2022 2,053,145 9,076 - 2.062 221 Allegiance Back 1.59;4 2/10/2020 2/10/20,22 5,120,132 20,520 - 5,140,652 Goose Creek ISD 500% 11/17/2020 2115/2022 407,100 - - 402,048 (5,052) East West Bank 1 54% 2/18/2020 2/1812022 5,126,242 19,937 - 5.146,178 East West Bank 0.17% 2/1912021 2/21/2022 11,096,354 4,756 - 11,101,109 FORT BEND COUNTY-REF 500% 6117/2020 3/1/2022 254,978 - - 251,898. 3,080) Allegiance Bank 0,40% 6/1712020 3/18/2022 10,049,963 10,022 - 10,059,985 - indeeendent Bank 0,40% 1/11/2021 4/11/2022 20039,691 20,204 - 20,059,895 - Ventex Community Bank 020% 215/2021 51512022 3,002,976 1,514 - 3,004,490 - Pros ent Prospenty Bank 020% 2/12/2021 5/12/2022 4,004,649 1,997 - 4,0,06,646 - independent Bank 030% 5/19/2021 5/19/2022 6,004,537 4,540 - 6,009,077 Allegiance Bank 045% 6117/2020 6117/2022 12,067,466 13,539 - 12,081,005 - Bank OZK 0,50% 7/9/2020 7/11/2022 1 10,058,652 12,544 - 10,071,196 - Veritex Community Bank 0.24% 215/2021 8/5/2022 3.003,571 1,817 - 3,005,388 - Pros en ProsEnjy Bank 0,20% 2/1212021 8/12/2022 3,003,487 1,498 - 3,004,985 - Arfin2tcn TX HGR EDU O 50% 4/2812021 8/15/2022 500,535 - 499,830 17051 �§exair Co Txb Ref 033% 9/23/2021 8/1512022 559,636 - 559,054 (582) Ci of B:Yan I X OA5% 11119/2020 811512022 500,660 - 499,945 715� Denton ISD 0,001/ 12/1712020 8/15/2022 498,465 - 498.845 380 City of Austin GO 0.27% 10/6/2020 9/112022 701,078 - - 69,9,832 (1,246) Prosperity Bank 020% 611/2021 9/112022 3,001,513 1,497 - 3,003,009 Veritex Community Bank 018% 3/5/2021 91512022 8,007,261 3,593 - 8,010,854 State of Texas 2.52% 10/14/2021 10/1/2022 - 5,113,850 - 5,079,400 (34,450) State of Texas 11.61°'/ 3/19/2021 10/1/2022 3,297,873 - - 3,279,965. 17,908 Prosperity Bank 0A0% 10I1512020 10/17/2022 6,,022,050 6,0018 - 6,028,058, Veritex Community Bank 0.26% 2/5/2021 11/4/2022 3,003,869 1,96 - 3,005,838 Prosperity Bank 020% 2/12/2021 11/1412022 3,003,487 1,498 - 3,004,985_ TBank 0A8% 11/24/2021 11/23/2022 - 4,000,000 4,000,000 - Bank OZK 028% 12/712020 '12/712022 5,010,557 3,511 5,014,068 -- Pros erit Prosperity Bank 0.20% 6/9/2021 1219/2022 10,005,042 4,990 10,010,032 - Veritex Carnnionity Bank 028% 1/6/2021 11612023 4,005,556 2,827_ - 4,008,383 - ,R Bank 0.57°/o 7/612021 116/2023 1,0100,000 1,443 1,001,443 I - Veritex Community Bank 030% , 21512021 2/6/2023 4,406,548 3,332 4,409,880 13 City of Round Rock Valley View Consulting, L.I....C. Market Value Comparison December 31, 2021 Issuer Coupon Settliernent Maturity Beginning Total Buys/ Total Sells/ Ending Market Change in Rate Date Date Market Value Increases Decreases Value Market Value FFCB 016'"o 11122/2021 2110/2023 - 4,994,267 - 4,979.927 (14,073) Eagle_Pass Texas 4,00%_ 617/2021 3/112023 678,830 - - 672,709 (6,121) Prosperity Bank 0,25% 3/512021 3/6t2023 10,012,609 6,242 - '10,018,851. Bank OZK 026% 3/8/20,211 3/8/2023 2,532,,416 1,648 - 2,534,064 - FFCB 0.13% 3/26/2021 M?312023 8,992,829 - - 8,,957,428 (35,401 ProsEerity Bank 0.20% 4112/2021 4/12/2023 5,004,193 2,496 - 5,006,689 - FFCB 1 0,13% 4/13/2021 4/1312023 4,9,93,589 - - 4,973,246 207 343 Prosperlty Bank -0200% 6A012021I 5/19/2023 10,006,741 4,990 - 10,011,732 Tentex Conimunfty Bank 0.20% 611/2021 6/1/2023 20,0101,082 9,978_ - 20,020,060 Bank 02K 0.20% 6/912021 619/2023, 8,094,054 4,012 - 8,008,065 M-43 R Bank O.70% 702021 7/612023 1,000,000 1,771 - 1,001,771 TreaSUU 1.25% 7/712021 7/31/2023 8,146,560 - - 8,080,304 L66,256) Veritex Community Bank 0.25% 7/30/2021 7131/2023 7,000,000 4,411 - 7,004,411 Arington TX HGR EDU 0.63% 4/28/2021 8/15/2023 1,461,767 - - 1,453,182 (8,585) Dallas ISO 4.00% 4/22/2021 8/15t2023 4,483,742 - - 4,422,159. (61,583) Veritex Community Bank 0.25% 8/2312021 8/23/2023 4,400,000, 2,773 - 4,402,773 Treasury O.25% 9/30/2021 9130/2023 9,992,188 - - 9,929,865 (62,323) Treasury 2.88% 11/22/2021 10/3112023 - 10,480,373. - 10.393,286 (69,605) FHLB 0.50% 11/12/2021 11/912023 4,997,700 - 4,977,639 (20,062) Treasury 2,88% 1 11/10/2021 11130/2023 5,312,653 - 5,204,693 (43,940) FHLB 0.50%, ! 12/7,12021 12/8/2023 - 7,973,098 - 7,956,935 (16,1,63) Sub TotallAverage Fund 000-Pooled investments 404,253,485 82,870,145, 62,126,410 424,427,641 (487,810) Fund 170-Interest&Sinking GO Bonds TexPool N/A 913012015 NIA 216196 2,942,989 - 31159,185 TexasDAILY N/A 4130/2016 N/A 505,089 9 314,037 191,0611 NexBwik N/A 2/27/2017 N/A 1,291,409 1,303 - 1,292,712 Sub Totat/Average Fund 170-Interest&Sinking GO Bonds 2,012,694 2,944,300 314,037 4,642,957 Fund 210-Interest&Sinkling Debt Service JPMoroan Chase N/A 9/30/2015 N/A 242,371 234,030 8,342 Sub Total/Average Fund 210-Interest&Sinkin Debt Service 242,371 234,030 8,342 Fund 462-2017 Bond Fund TexPool N/A 5/301/2017 N/A 3,315,247 15,991 - 3,331,238 NexBank N/A 3/301/2020 N/A 1,609,677 1,624 - 1,6'11,300 East West Bank &26% 112/21/2020 12/211202'1 6,012,150 2,613 6,014,763 - East West Bank 0.26% 12128/2021 6028/2022 - 6000,171 - 6,000,171 Tub TotallAverage Fund 462-2017 Bond Fund 10,937,074 6,020,399 6,014,763 10,942,710 Fund!465-Road CO Bond Fund TexPool N/A 9/1/2020 NtA 439 32,081 439 32,081 Texas Capital Bank NIA 6/112021 WA 12,285,592 4,081 2,250,316 10,0,39,357 Independent Bank 0.40% 12/7/2020 12/7/2021 8,024,078 - 8,024,078 - East West Bank 0,18% 1219/2021 619/2022 - 8,000,907 - 8,000,907 Prosperity Bank 020% 7/612021 7/6/2022 10,003,398 4,989 10,008,386 Prosperity Bank 0.20% 6/112021 9/1/2022 7,003,529 3,493 7,007,022 Veritex Community Bank 1 0.30% 2/5,12021 2/6/2023 1 5,608,334 1 4,2415.612.575 C 'Sub TotallAverage Fund 466-Road O Bond Fund 42,925,369 8,049,792 %274,i32 40,700,329 Fund 591-Reserves Fund !TexPool N/A 9130/2015 N/A 8,722 1 8723 NexBank N/A 4/29/2019 N/A 857,453 865 858,318 'Sub Total/Average Fund 591 -Reserves Fund 866,175 866 867,041 14 City of Round Rock Valley View Consulting, L.L.C. Market Vallue Comparison December 31,, 2021 ]Issuer Coupon Settlement Maturity Beginning Total Buys/ Total Sells/ Ending Market Change in Rate bate Date Market Value Increases Decreases Value Market Value Fund 602-Interest&Sinking(Revenue Bonds TexPaal N/A 9/34/2015 N/A 2,343,605 1,583,931 - 3„927 536 - Sub Total/Average Fund 502-Interest&Sinking Revenue Bonds 2,343„605 1„593,931 - 3,927,536 - Fund 605-Kalahari Debt Service Reserve T6xP60I ..., N/A 8/30/2019 ,.. . , (VIA.... 253,044 ......... 24. ........................ a 253,069 Sub Total/Average Fund 605-Kalahari Debt Service Reserve 253,044 24 - 253,068 Fund 863-Drainage Utility Revenue Bond TexPool N/A 10/31/2015 Nle, 463,446 40 1 241,353 1 222,1321 - NexBank, N/A 8130/2020 N/A 216,183 218 744 215,657 - Sub Total/Average Fund 86:3-Drainage Utility Revenue Band 579,529 257 242,097 437,789 Teta/l Average $ 454,513„446 $-1 01A69 713 79,206,169 $ 486,207,412 $ 487,8101 15 City of Round Rack Valley View ConsUlking,l_.1...C. Holdings by Allocation and Portfolio (Fun ) September 30, 2021 Issuer Coupon Credit Rating Settlement Face Amount/ Book V'alue Market Mai WRY Date Days to YTM @ Rate Data Sha:res F Maturity Book Fund 000-Pooled Investments NexBank 0,40% '11/2982016 5 36,091,817 $ 36,091,817 100.00 $ 36,091,817 N/A 1 0.40% TexasDAILY 0,02% AAAm 6/1/2021 1,799,103 11,799,103 100.00 1,799,103 N/A 1 0.02% Texas Capital Bank 0.15% 7/1/2021 7324,273 7,724,273 '100.00 7,724,273 N/A 1 0.15% Veritex Conirnun!4 Batik 0.08% 9/1/2020 175,902 175,902 '100,00 175,902 N/A 1 0.08% JPMorgan Chase 0,14% 9130/2015 20,145,855 20,145,855 100,00 20,145,855 N/A 1 0,14% TexSTAR 0.01% AAAai 9/30/2,0`15 200,527 20i0,527 100.00 200,527 NIA 1 0.01% ITexPool 0.04% AAAm 1 9/3012'015 13,349,268 13349,268 1 10000 13,3,49,268 WA 1 0,04% �Prosperity Bank 0.15% 9/1412021 13,000,855 13 000,855 100.00 13,000,855 N/A 1 0,15% TexasDAILY 0.02% AAAm 9/3012015 5,048,440 5.048,440 100.00 5,048,440 N/A 1 0.02% Prosperity Bank 0.15% 9/1412021 2,000,132 2,000,132 100.00 2,000,132 N/A 1 0.15% Veritex Community Bank 1.71% 10/3/2019 10,303,235 '10,303,235 100,00 10,303,235 10/4/2021 4 1.71% East West Bank 1.65% 112712020 6J58,587 6,168,587 10000 6,168,587 10/2712021 27 1,65% East West Bank 1.54% 2/18/2020 6,151,490 6,151,490 100.00 6,151,4910 110912021 50 1.54% East West Bank 1.64"!5 1 11/22/20/9 5,154,890 5,154,890 100.00 5,154,890 11/22/2021 53 1.64% Independent Bank 040% 12/7/2020 8,024,046 8,024,046 1 100.00 8,024,046 12/7/2021 68 0.40% Veritex Community Bank 1.67% 1212012019 5,148,261 5,148,261 100.00 5,148,261 121201'2021 811 1.67% Bank OZK 170% 1/28/2020 8,230,136 8,230,136 100,00 8,230,136 1124/2022 6 1.70% R Bank 175% 1127/2020 2,053.145 2,053,145 100,00 2,053,145 1/27/2022 119 175% Ale lance Bank 1,59% 2/10/2020 5,120,132 5,120,132 '100,00 5,120,132 1 2/10/2022 133 1.59% Goose Creek ISD 5,00% Aaa/4AAA 11/1712020 400,000 407,024 10138 407,100 2/15/2022 138 0.33% East West Bank 1.'54%0 2/18/2020 5,126,242 5,126 242 10000 5,126,242 211812022 141 1,54% East West Bank 0.17% 2/19/2021 11,096,354 11,096,354 100.00 11,096,354 212182022 144 0.17% FORT BEND COUNTY-REF 5.00% Aal/-/AA+ 6/17/2020 250,000 254,150 101.99 254,978 31112022 152 0,98% Allegiance Bank 0,40% 6117/2020 10,049,963 10,049,963 100.00 10,049,963 3/18/2022 169 0,40% Independent Bank 0.40% 111112021 20,039,691 20,039,691 100.00 20,039,691 4111/2022 193 0.40% Veritex Community Bank 020% 215/2021 3,,002,976 31,002,976 100.00 3,002,976 5/5/2022 1: 217 020% Prosperity Bank 0.20% 2/12/2021 4,0,04,649 4,004,649 100.00 4,004,64 5/12/2022 224 020% Independent Bank 0.30% 5/1912021 6,004,537 6,004,537 100.00 6,004,537 5119/2022 231 0,30% Alfegiance Bank 0,45% 6117/2020 12,067,466 12,067,466 100.00 12,067,466 6117/2022 260 0.45% Bank OZK 0.50% 7/9/2020 10,058,652 10,058,652 100.00 10,058,652 7/11/2022 284 0.50% Veritex Community Bank 024% 215/2021 3,0103,571 3,003,571 100.00 3,003,571 81512022 309 0,24% Prosperity Bank 020% 2/12/2021 3,0013,487 3,003,487 100,00 3,003,487 8112/2022 316 0.20% Bexar Co Txb Ref 0.33% A2/ANA- 912312021 560,0100 560,000 99.94 8!1582022 319 0.,33°/m Arlington TX HGR EDU 0Z0% -/AAA/- 4/28/2021 500,000 500,000 10011 500,535 8/1512022 319 0,50% Denton VSD 0.00% -/AANAAA 1211712020 500,000 497,989 99.69 498,465 8/1512022 319 0,46% City of B!yan TX O.45% -/AAI- 11/19/2020 500,0001 500,000 '100.13 500,660 811512022 3191 0.45% City of Austin GO 0.27% Aal/AAA/AA+ 10/612020 700,000 700,000 100.15 701,078 9/112022 336 0.27% Prosperity Bank 0.20% 1 6/1/2021 3,001„513 3,001,513 100.00 3,001,513 9/112022 336 0,20% Veritex Commun 7ty Bank 0.18% 3/512021 8,007,261 8,,007,261 100.00 8,007,261 915/2022 340 018% State of Texas 1,61% Aaa/AA/V- 3119/2021 3,250,0,00 3297,516 101,47 3,297,873 10/1/2022 366 015% Prosperity Bank 0A0% 10/15/2020 6022,050 6,022,050 100,00 6,022,050 110/17/2022 382 0.40% Vehtex Community Bank 0.26% 2/5/2021 3,003,869 3,003,869 100.00 3,003,869 11/4/2022 400 0.26% Prosperity Bank 0.20% 2/12/2021 3,003,487 3,003,487 100-00 3,003,487 11114/2022 410 0,20% Bank OZK 0,28% 1217/2020 5,010,557 i 5,010,557 100.00 5,010,557 12/712022 433 0.28% Prosperity Bank 0.20% 619/2021 10,005,042 1U05,042 100.00 10,005,042 1219/2022 435 0.20% Veritex CommuNty Bank 0.28% 1/6/2021 4,005,556 4,005,556 100.00 4,005,556 11612023 463 0.28% R Bank 0,57% 7/6/2021 1,000.000 1,000,000 1 100.00 1,000,000 116/2023 463 0.57% Veritex Commuini!y Bank 0.30% 2�/5/2021 4,406,548 4,406,548 1001,00 1 4,406,548 1 2/612023 1 494 0,30% 16 City of Round Rock Valley View Consulting, L.L.C. Holdings by Allocation and Portfolio (Fun September 30, 2021 Issuer Coupon Credit Rating: Settlement Face Amount/ Market Value Market Market Value Maturity Date Maturity YTM @ Rate Date Shares Price Maturity Book Eagle Pass Texas 4,001% -/AA-1- 6/7/2021 645,000 679,671 105.25 678,830 311/2023 517 0.20% Pros exit Bank 025% 3/5/2021 1 O,01 2,609 10,012,609 100.00 10,012,609 316/2023 522 0.25% Bank OZK 0.26% 3/8/2021 2,532,416 2,532,416 100.00 2,532,416 3/8/2023 524 0.26% Federal Farm Credit Bank 0.13% AaaiAA+/AAA 3/26/2021 9,000,000 8,996,664 99.92 8,992,829 3123/2023 539 015% Pros pBrit y Bank 0.2�O% 4,112/2�021 5,004,193 5,004,193 100.00 5,004,193 4/12/2023 559 0,20% 0/ 0 FFCff 0�I all/. Aa81AA4-/AAA 411372021 4;994;937. .......""""""""""99:87 411312023 560 019% Prosperily Bari 20-1% 511 912021 10,006,741 10,006,741 100 00 10,006,741 5/1912023 596 0.20% 'Veritex Community Bank 0.20% 6/1/2021 20,010,082 20,010,082 100.00 20,010,082 6/1/2023 609 0.201%6 Bank OZK 010% 619/2021 8,004,054 8,004,054 100.00 8,004,054 619/2023 617 0.20% R Bank 0,70% 716/2021 1,000,000 1,000,000 '100.00 1'000,0001 716/2023, 6441 07016 Treasury' 125% AaalAAA/AAA 7/7/2021 8,000,000 8,150,281 101.83 8,146,560 7/31/2023 1 -669 0,22% Verilex CornmunIty Bank 0.25% 7,130/2021 7,000,000 7,000,000 100-00 7,000,000 7/31/2023, 669 0.25% DaHas ISI 4.00% Aaa/AAAJAAA 4/22/2021 4,195,000 4,487,847 106,88 4,483,742 811512023 684 0.26% Artington TX HGR EDU 0.63% -/AAA/- 4/2'812021 1,460,0100 1,460,,0100 10012 1,461,7'67 8115 2023 684 0.63% �Veritex Community Bank ....... 025% 812312021 4,400',000 4,400',000 100.00 4A00.000 812312023 692 0.25% Treasury . f�-Aaa/AANAAA 9/30/2021 10,0 9',990,820001,000 ,990,820 9992 9,992,188 9130/2023 730 0,30% I 0,25V !Sub Total I Average l 0.53% 4013,743,657 1 404,260,556 100.1!3 404,253,485 1........... 271 0,45% Fund 170-Interest&Sinking GO Bonds TexasIDAILY 0.02% AAAm 4/30/2016 5015,089 505,089 100. O 505,089 N/A 1 0.02111 Nex8ank 0.401'1/ 2127120117 1,291,409 1,291,409 100.00 1,291,409 N/A 1 0.40% TexPool 0.04% AAArn 9/30/2015 216,196 216,196 100.00 216,196 N/A 1 0.04111 Sub Total/Average 0.27% 2,0'12,694 2,012,694 1011 2,01!2,694 1 0,27% Fund 210-interest&Sinking Debt Service JPMogan Chase 0A4% 1 9/30/2015 242,371 1 242,371 100.00 242,371 N/A 1 0.14% Sub Total/Avera ie 0,141X1 242,371 1 242,371 100-00 242,371 1 0A4% Fund 462-2017 Bond Fund TexPool 0,0 4*/6 1 AAArn 5130/2017 3,315,247 1 3,315,247 100.00 3,315,247 NIA 1 1 0,04% Nex[Bank 0A0% 3/30/2020 1,609,677 1,609,677 100.00 1,609,677 N/A 1 0,40% East West Bank 0.26111 12/21/2020 6,012,150 6,012,150 100.0'0 6,012,150 12/21/2021 82 0.26% Sub Total/Average 0,21% 10,937,074 10,937,074 100.00 10,937,074 46 0.211X1 Fund 465-Road CO Bond Fund Texas Capital Bank 0.15% 6/1/2021 12,285,592 12,285,592 100.00 12�,285,592 N/A 1 0,15% TexPool 01.04% AAArn 9/1/2020 439 439 '100.00 439 N/A 1 0,04% Indeeendient Bank 0,40'% 12/7/2020 8,024,078 8,024,078 100,00 8,024,078 12/7/2021 68 0.40% Proseerity Bank 0.20% 7/6/2021 10,003,398 10,003,398 100.00 10,003,398 716Y2022 279 0.20% Prosperity Bank 0.2011/0 61112021 7,003,529 7,0103,529 100,00 7,003,529 911/2022 336 0.20% Vertex Community Bank 0.3011/6 2)512021 5,608,334 5,608,334 100.00 5,608,334 216/2023 494 0.30% Sub Total I Average i-0.24% 1 1 1 42,925,369 42,925,369 100.00 42,925,369 1971 0.24% Fund 59'1 -Reserves Fund TexPool 0,04% AAAni 9/3012015 8,722 8,722 '100.00 8,722 N/A 1 0,04% NexBank 0,40% 11 4129/2019 857,453 85,7,453 100,00 857,453 N/A 1 0A0% Sub Total/Average 1 0.404/1 866,1175, 1 866,175 1 100.00] 866,1751 11 0'.401X1 Fund 602-Interest&Sinking Revenue Bonds iTexPool 0.04% 1 AAAA 9/30/2015 2,343,605 2,343,605 100,00 2,343,605 N/A 11 0.04% ISub Total/Average 0.041/ 1 1 2,343,,6051 2,343,605 100.00 2,343,605 11 0.04111 17 City of Round Rock Valley View Consulting, L.L.C. Holdings by Allocation and Portfolio (Fund) September 30, 2021 Issuer Coupon Se Credit Rating Date Price Settlement !Face Amount/ Market Days to YTM Rate Book Value Market ValueMaturity Date @ Maturity I Book Fund 605-Kalahari Debt Service Reserve TexPool 0.04% AAArn 8130/2019 253,044 253,044 1 100r00 253,044 N/A 1 0.04% Sub Total I Average 0,040/6 ---------- 253,044 253,044 100.00 253,044 1 0-04% Fund 863-Drainage Utility Revenue Bond NexBank 1 0.40% 1 8/30/2020 1 216,183 216,183 100,00 216,183 NFA 1 0,40% TexPool 0.04% AAArn 10/31/2015 463,446 463,446 100.00 463,446 N/A 1 0.04°l6 Sub Total/Average 0.15% 679,629 679,629 100.00 679,629 1 0.15% Total I Average 0.49% $ 464,003,618 $ 464,520,518 100.11 $ 464,513,446 999 0.42% 18 City of Round Rock Valley View Consulting, L.L.C.