The URL can be used to link to this page

R-2021-043 - 2/11/2021RESOLUTION NO. R-2021-043 WHEREAS, Chapter 2256, Texas Government Code, Section 2256.023 of the Public Funds Investment Act states that a written report of investments be submitted to the governing body at least quarterly; and WHEREAS, a Quarterly Investment Report for the quarter ending December 31, 2020 for the City of Round Rock has been submitted to the City Council; and WHEREAS, the City Council desires to acknowledge the receipt and acceptance of the attached Quarterly Investment Report, Now Therefore BE IT RESOLVED BY THE COUNCIL OF THE CITY OF ROUND ROCK, TEXAS, That the Quarterly Investment Report, attached hereto as Exhibit "A" and incorporated herein, is hereby received and accepted. The City Council hereby finds and declares that written notice of the date, hour, place and subject of the meeting at which this Resolution was adopted was posted and that such meeting was open to the public as required by law at all times during which this Resolution and the subject matter hereof were discussed, considered and formally acted upon, all as required by the Open Meetings Act, Chapter 5 51, Texas Government Code, as amended. RESOLVED this 11 th day of February, 2021. CRATf MORAN, Mayor City RouncWock, Texas ATTEST: SARA L. WHITE, City Clerk 0112.20212-1 00464539 K T XA QUARTERLY INVESTMENT REPORT For the Quarter Ended December 31, 2020 Prepared by Valley View Consulting, L.L.C. The investment portfolio of the City of Round Rock, Texas is in compliance with the Public Funds Investment Act and the Investment Policy and Strategies. signatures Withheld for security purposes Chief Financial Officer signatures withheld for security purposes Accounting Manager Valley View Consulting, LLC signatures withheld for security purposes Deputy Chief Financial Officer signatures withheld for security purposes Treasury Accountant Dated EXHIBIT „A„ _ I 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 detennined using standard performance formulas, are not representative of total return yields and do not account for investment advisor fees. Summary Holdings by Investment Category (Security Sector) December 31, 2020 Description YTM a� Cost Book Value Market Value, Cash 0,19% $ 51294,914 $ 51294,914 Certificates of De osit 1.42% 248,009,389 2481009,389 Local Government Investment Pool 0.09% 35,754,834 35,7541834 Money Market Accounts 0.37% 5411101848 541110,848 Municieal 0.50% 217480,906 2115011142 .Total I Average e06% $ 364965Op890 $ 3641671,127 September 30, 2020 Description YTM � Cost ook'Value Market Value Cash 0.17% $ 5,8057,5.7 $ 51805,957 Certificates of Deposit 1.77% 25114597497 2511459,497 Local Government Investment Pool 0.15% 19,222,939 19,222,939 Money Market Accounts 0,37% 571904,552 5719041552 Municipal 0.58% 16,308,884 16,339,160 USAgency 2.87% 51999,985 610067319 Total I Average 1.39% $ 356,7Q1,813 $ 356,738,424 Total Portfolio TexPool Yield Rolling Three Mo. Treas. Yield Rolling Six Mo. Treas. Yield Rolling 1 Yr. Treas. Yield Rolling 2 Yr. Treas. Yield Interest Income (Approximate) Total Portfolio Pooled Funds Average Yield Current Fiscal Year - Quarter (1) to -Date (2) InO6% IzO6% 0.09% 0.09% 0.09% 0.09% 0,11% 0.11% 0.36% 0.36% 1.17% 1.17% Investment Income (3) $ 111021529 $ WAM at 12/3112020 195 days 201 days 11102,529 Policy WAM Max 540 days 540 days (1) Average Yield calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or account for advisory fees. (2) Fiscal Year -to -Date Average Yields calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or account for advisory fees. (3) Investment Income includes coupon interest, accrued interest, and discount and premium amortization. City of Round Rock Page 1. Valley View Consulting, L.L.C. Economic Overview 12/31/2020 The Federal Open Market Committee (FOMC) maintained the Fed Funds target range at 0.00% to 0.25% (Effective Fed Funds are trading +/-0.10%), and projected that reduced rates could remain into 2024. Second estimate of Third Quarter GDP was finalized at +33.4%, but still remains 3.5% below pre -pandemic levels. Crude oil traded above $50 per barrel. Employment/ Unemployment continues modest improvement. The Stock Markets reached new highs. Housing continues adding positive economic activity. Additional fiscal stimulus passed and was signed by the President. The Yield Curve steepened slightly from last quarter end. �n v...�x....v......N.k..............�.........��.µ A......Treasur Yield .Curues..�.....-....�.h... h.. v...vµ.. Avv.....v.. �A......v...�v...A..� . k S&P 500 2.00 1.50 1.00 0.50 0.00 O� 0 o,a, -December 31, 2019 September 30, 2020 6.00 5.50 5.00 4.50 4.00 3.50 3.00 2.50 2.00 1.50 1.00 0.50 0.00 P� *-wm,xnx,, December 31, 2020 j \15 fro NR) 4 Six Month T-Bill Two Year T-Note Ten Year T-Note 4,000 3,750 3,500 3,250 3,000 2,750 2,500 2,250 2,000 1,750 1,500 1,250 1,000 750 500 250 0 Q0 NZ NN 1\� -3 I\,` �� N10 1\1 1\`b K°) 14 , , , , , , , , , , , , 4a� 4a� 4a� ,ate 41 ��.� �� Sam Say 4�� sz. le 3.50 US Treasury Historical Yields - Since Nov 2015 3.00 2.50-- A 2.00 1.50 - - 1.00 0.00 1\1' ;\� ;�� \s ,\b ,'�� '�� '$ : \b -\'6 N� ,'�°' Ng,tip `L� 2p 'rL' N°�F 8� may PJo; boy Fer, �a�� P`�o; ��' F e� may PJo; �oJ� PJo; *Six Month T-Bill Two Year T-Note Ten Year T-Note City of Round Rock Page 2. Valley View Consulting, L.L.C. Holdings by Investment Category December 31 Pooled Funds Debt Service Funds Debt Service Reserve Funds Capital Project & Special Purpose Funds Total Portfolio Description Book Value %of Portfolio Book Value % of Portfolio Book Value % of Portfolio Book Value % of Portfolio Book Value % of Portfolio Cash $ 5,289,338 10/ /0 $ 5,575 0% $ 0% $ — 0% $ 5,294,914 1% Certificates of Deposit 214,354,199 59% 6,001.726 2% — 0% 27,653:464 8% 248,009,389 68% Investment Pools 30,782,690 8% 3,446,790 1% 348,731 0% 1,176,623 0% 35,754,834 10% Money Market Accounts 41,772,809 11% 1,287.232 0% 854,679 0% 10,196,127 3% 54,110,848 15% Municipal 1 19,280.906 1 5% 1 — 0% — 0% 2200,000 1% 21.480,906 6% Total I Average 1 $ 311,479,942 1 85% 1 $ 10,741,324 1 3% $ 1,203,411 1 0% 1 $ 41,2 2 6,2 1 4t1 I % $ 364,650,890 100% Portfolio Balances (Millions) ........... . .......... .... ..... ...... .......... .. . ....... . .. ........ . .......... ..... ........ ....... I ..... ...... ..... ........ . ..... I . ........... .... ... ....... . I .......... -.. - .... ........... . ............. $0 Pooled Funds DS Funds DSR Funds CP&SP Funds a Cash ............. * Local Government Investment Pool *Money Market Account Total Portfolio OMunicipal oCertificates of Deposit City of Round Rock Page 3. Valley View Consulting, L.L.C. Investment Holdings by Investment Category December 31, 2020 Description Book Value % of Portfolio Portfolio Limitation Cash $ 5,294,914 1.5% 100% Investment Pools 35,754,834 9.8% 100% Money Market Accounts 54,110,848 14.8% 75% Certificates of Deposit 248,009,389 68.0% 85% Commercial Paper — 0.0% 10% / 5% Municipal 21,480,906 5.9% 35% / 5% US Agency — 0.0% Combined 75% US Treasury — 0.0% Total ! Average $ 364,650,890 100% PASSED Quarterly Transactions By Investment Category December 31, 2020 Description Buys Sells Maturities Calls Interest Net Cash Equivalent Depositl(Withdrawal) Cash $ — $ — $ — $ — $ — $ (511,043) Investment Pools — — — — 4,850 16,531,895 Money Markets Accounts — — — — 52,462 (3,793,704) Certificates of Deposit 41,036,097 — 44,486,205 — 1,059,271 — Commercial Paper — — — — — — Municipal 5,324,065 — — — 73,250 — US Agency — — 6,000,000 — 85,800 — US Treasury — — — — — — Totals $ 46,360,162 1 $ — $ 50,486,205 $ — 1 $ 1,275,633 $ 12,227,148 Portfolio Balances (Millions) Order of Liquidity $400 $350 o Cash Investment Pools $300 __ _ _ ,,:.' .................o s•r Local Government Investment ::., Pool $250 { __ _ .. _ ;::::::<: _ rrf• ^,i. - o Money Market Account .......:::. ::... .: ir: N•:{r .. %f f: <r .i: is is is is ® US Treasury Cash %> >v 1.5% $150 Y r„<r > rl'+" o US Agency $100 ii: :>: .... :Yfiirr v q ?r >. unicipal Municir 50Mg_. o e o C rtificates of Deposit 0 >kr. _.. ::.:.:.... 12/31 /19 3/31 /20 6/30120 9/30/20 12/31 /20 Portfolio Composition Money Market December 31, 2020 Arrni jnts Certificates of Deposit 68.0% City of Round Rock Page 4. Valley View Consulting, L.L.C. Portfolio Balances By Fund (Millions) $400 $350 m Capital Project & Special Purpose Funds © Debt Service Reserve Funds $200 a Pooled Funds '$0 I A kx:KII V, Rl>I AWA rz A W-0 oNA NA NIb N11>J NOJ NIb NIb N\IV -3P 4P -3\'b City of Round Rock Page 5. Valley View Consulting, L.L.C. 2s60 2n5O 2840 2w30 2020 2810 2aOO 1890 1w80 1870 1e60 1e50 1840 1e30 1820 1810 1600 0890 Oe80 0870 Ow60 0050 0840 On30 Oe20 Oslo 0900 City of Round Rock Pooled Funds Performance •.t•• .:.♦•..: hN•. • .. 1•t:. • : h•:.Y: hY.Y•• .. • .'•♦'.t•.. • • . • :Y. J.t'.♦L'. • :.Yt'. • ...... • . • Y: h•. • :.Y: h . ' Y. .. / YY • . .. .. •. Y • • • • • • • • • • • • • • • • • Y • • • • • • • •• ♦♦• Y . '::: i ' • • .: Y.• Y: • t♦♦tYJ: r: •.•: • YK'• � h• '.YY :K•.Y.tY:.:Y.••YtY.tYJ:::: r:.W.t:tY:.YV\YY1hM1'.YYW.KtW►btYN.tKt:V►tY.YK'.tYM1YI♦YI�YtW.Y.tYJ!•YW.•.•Vlr' KY.•/♦W�LWJV.W.YAKV/.t:1hYM`.WIWLYKtYhhY.•.KtYYYYtYW.YWN.YllMYYJ.VhVL••Y.VV♦YVN1: .tYNr. N.t•hh:K•.tYYhtY/. :YtYNlNi:/JI'.Y.Y/.Wh'.ttr!I♦YNI:YYVttYrlh•.YJ: hYlN: JJJhhYMY•:.tt•.•I♦Y.••W'.YtKWJWtKYY•YAYVY.KYY♦Y.ttttlttY.tYY•.YY.:W.Wrh•N.•. JJI.WAY ♦ } r ♦ .w •r, v %rJr :r�ffv Y ti f tt JJI y ♦ ♦ L I r L AMW Maw } AAW lr . rJ ♦ ♦ t rJ`t J { 1 r y } r AMaw f J t� ME ISM moo NL WVVY- 0004 WOM S f ! r i f tif: I i$ L V } l t `J 1 { { ♦ ♦ kZ kKj`* Qj 111:j'* Q, !Q)� IICj'*' 1� Round Rock am 4w Rolling 1.5 yr Treasury (Policy WAM max) 'W N TexPool Rolling 9 mo Treasury Zo�yo o�yo 10 D\ CO\ 0j City of Round Rock Page 6. Valley View Consulting, L.L.C. Holdings by Allocation and Portfolio (Fund) Dece ber 31, 2020 . .. ....... . ....... ... .. ... ft-suer 01 a---po .. ...... .. . Ra-te' .1id.1t -Ratin-9. ... ..... ...... . ... . ............... . ... ... ... . .. ..... .. Ieft .-W ........ .... .. .... .......... . ........ . ......... . "Face-Amo' .... ... U.1t. ... ... ... ... .. .. ........... .. ....... ... . ....... . . ...... ... .... ....... -M Market foe'* fto-kWilue. "Va ............. ... . ... . .......... ..... ....... . . ..... . . . .. ........... ....................... ... .............. ...... .. ....... p .. . .. . ..... ............ .... .... ....... .. ....... ... tu aW ........ ...... . ... ... ...... .. . ....... . ... . ... ... ......... ... . Y . ..... ffm k . ... .... ..... Fund 000 Pooled Inves ents NexBank 0.45% 1 1/29/2016� $ 3598249219 $ 35Y8241219 100.00 $ 35,8249219 N/A 1 0.45% Veritex Community Bank 0.14% 09/01/2020 59948,591 51,9489591 100.00 5,948,591 N/A 1 0.14% JPM' ipmoEgan Chase 0.19% 09/30/2015 59289,338 592899338 100.00 592899338 N/A 1 0.19% T �ex TexSTAR 0.07 % AAAM 09/30/2015 2009499 2009499 100.00 2001499 �N/A 1 0.07% kTexPool Tex 0.09% 09/30/2015 2995799495 299579,495 100.00 2995799495 N/A 1 0.09% Tex'e TexasDAILY 0.09% -IAAAm AAAm 09/30/2015 11002,696 190029696 100.00 11002,696 N/A 1 0.09% 'nde Inde endent Bank 1.85% 10/04/2019 50939206 57093,206 100.00 590939206 01/04/2E1 4 7.85% Ea t East West Bank �ir 2.78% 01/11/2019 109564,481 10,564,481 100.00 101564t481 01/11/2021 11 2.78% Od in Bank 0 2.82% 02/12/2019 69512t643 61512t643 100.00 6Y5129643 02/12/2021-1- 2.82% Cedai Cedar Hill ISD Ref-Txbl 0.00% Aaa/-/AAA 11/14/2019 5009000 4989806 99.93 499,640 02/15/2021 46 1.93% Carrollton Farmers Branch GO k Carr, 5.001% Aaa/AAA/- 04/09/2020 279307000 27944,770 100.55 21945Y969 02/15/202 46 0.95% 004 Goose Creek IFD� G q 5.00% Aaa/-/AAA 11/17/2020 500,000 502,941 1000,53 502,655 02/15/2021 46 0.29% Fast East West Bank 2.71% 02/20/2019 11 Y0441530 119044,530 100.00 1190449530 02/19/2021 50 2.71% F 0 R FORT BEND COUNTY -REF 5.00% Aal/-IAA+ 06/17/2020 250,000 2511690 100.74 251,853 03/01/2021 60 0.87% Pros Prosperity Bank �de 2.74% 03/01/2019 296229914 27622,914 100.00 21622,914 03/01/2021 60 2.74% I n Independent Bank i 1.86% 09/30/2019 51117,273 WOW 59117,273 100.00 511-179273 03/30/2021- 89 1.86% I pnd e Inde endent Bank 1.80% 10/11/2019 91163,198 99163,198 100.00 91163,198 04/12/2021 102 1.80% Independent Bank Inde p 2.15% 07/22/2019 51136,111 51136,111 100.00 5,1369111 04/22/2021 112 2.15% 'Ie Alle iance Bank PIndeg 1.70% 02/10/2020 51063,904 50630904 100.00 51063,904 05/10/2021 130 1.70% Independent Bank 0.65% 05/16/2020 59216,867 50216,867 100.00 59216,867 05/17/2021 137 0.65% BBV BBVA kB7e 1.94% 08/27/2019 591319113 591311113 100.00 59131,113 05/27/2021 147 1.94% Bexar County Flood GO Ref 5.00% Aaa/AAA/AAA 04/0712020 219309000 299819462 102.16 21993p3to 06/15/2021 166 1.10% erit Veritex Community Bank...., KB 1.67% 12/20/2019 51084,256 5,0849256 100.00 57084t256 06/21/2021 172 1.67% BOKF, NA 0 K 2.00% 06/27/2019 21000,000 290002000 100.00 210009000 06/24/2021 175 2.00% Veritex Community Bank 1.74% 09/30/2019 59109,882 59109,882 100.00 59109,882 06/30/2021 181 1.74% BBVA 1.77% 10/03/2019 59104,085 591047085 100.00 51104,085 07/05/2021 186 1.77% Inde Inde endent Bank PRB 2.15% 07/22/2019 50136,111 59136,111 100.00 571360111 07/22/2021 203 2 .15% a r R Bank 1.80% 01/2 /2020 2PO279207 290279207 100000 2,027,20-7- 07/27/2021 208 1.80% enI Denton ISD rEast 0.00% -/AAA/AAA 12/17/2020 5001000 4991030 99.81 4991070 08/15/2021 227 0.31% East West Bank 1.64% 11/22/2019 51092,046 590922046 100.00 51092,046 08/23/2021 235 1.64% Stat State of TX Transportation 4.00% MlGl/SP1+/Fl+ 09/02/2020 91000,000 91223,414 102.49 99224,280 08/26/2021 238 0.20% BBVA BBV' 1.87% 08/27/2019 3,075,794 31075,794 100.00 39075,794 08/27/2021 239 1.87% Sect Security tate Bank & Trust 2.09% 09/05/2019 711849592 711849592 100.00 71184,592 256 Vent Veritex Community Bank 1.71% 10/03/2019 1011729574 101172Y574 100.00 10,172,574 10/04/2021 �277 1.71 % ast East West Bank FE�a 1.65% 01/27/2020 61092929 690929929 100.00 69092,929 10/27/2021 300 1.65% St East West Bank 1.54% 02/18/2020 61081,043 61081,043 100.00 61081,043 11/19/2021 323 1.54%- ast East West Bank rIn 1.64% 11/22/2019 51092,046 510929046 100.00 5,0927046 11/22/2021 326 1.64% Independent Bank d e 0.40% 12/07/2020 89000,000 890009000 100.00 890009000 12/07/2021 341 0.40% Veritex Community Bank ent rBanl 1.67% 12/20/2019 590849256 51084,256 1 on -no 51084,256 12/20/2021 354 1.67% Bank OZK 1.70% 01/28/2020 8Y 1259785 81125,785 100.00 8Y125785 01/24/2022 389 1.70% R Bank R Bc kAllec 1.75% 01/27/2020 27026,447 29026,447 100.00 290269447 01/27/2022 392 1.75% Allegiance Bank 1.59% 02/10/2020 51059,753 51059,753 100.00 57059,753 02/10/2022 406 1.59% 0 Goose Creek ISD [a0' 5.00% Aaa/-/AAAl- 11/17/2020 400VOOO 4201920 105.23 420904 02/15/2022 411 0.33% Eas East West Bank --M 02/18/2020 5,067,536 5,067,536 100.00 510671536 02/18/2022 414 1.54% FOR FORT BEND COUNTY -REF PA 11.54% 5.00% Aal/-/AA+ 06/17/2020 2509000 261,604 105.52 263,793 03/01/2022 425 0.98% I I �e Allegiance Bank 0.40% ---106/17/2020 109019,845 10,019,845 2 0.40% 'Ie Alle iance Bank PBa 0.45% 06/17/2020 121026,793 12,026,793 �100.00 100.00 �1090199845 12YO26,793 �03/18/2022 06/17/2022 533 0.45% n k Bank OZrx 0.50% 07/09/2020 101020P976 10,020,976 100.00 10,0209976 07/11/2022 557 0.50% Ded Denton ISD 0.00% -/AAA/AAA 12/17/2020 5009000 4969268 99.39 4969925 08/15/2022 592 0.46% Cit of Bryan TX Cil 0.45% -/AA/- 11/19/2020 500,000 -500,000 100.17 500,845 08/15/2022 592 0.45% Citv Cit of Austin GO 0.27% Aal/AAA/AAA 700,000 700,000 100.17 7019218 09/01/2022 609 0.27% Prosperity Bank 0.40% 110/06/2020 10/15/2020 69004,001 690049001 100.00 61004,001 10/17/2022 655 0.40% Bank OZK 0.28% 12/07/2020 5OOOYOOO 100.00 510002000 12/07/2022 706 0.28% Sub Total Average Is38% 1500000000 �311j16%036 311 v479,942 M100811 31194999563 201 IeI8% City of Round Rock Valley View Consulting, L.L.C. Holdinas bv Allocation and Portfolio (Fund) uecemioer;si, zuzu ............ . ..... . ........ .. .... .. . .. ... ..... .. ... oupon ....... . ... ........ .. .... . ... .... :.-Credit-A tj no. .... ......... . ............ ....... .... .... .. ..... . ..... . . ............ . . . ....... ................. ........ ... . ........... . . . . ..... ........ ..... . . . ....... .. .... .... .... ............ kF'u ... ...... . eftlm-en. . -S .. .... . ............ .. . . ........ - Q ........ Fat Am-ountJ- .. ............ ... .... .. . . ......... ...... .... .. ....... ...... . ... . ........... ..... . .... .. .. . ...... ....... . .. .... . . ..... Aa . .. ... 'ft'.k:V glue' .......... . ....... ... . . ... . ............ .... ...... ... . ............. . ......... .... ...... ..... . ...... .. - ...... .. . .... .. for. .......... . ................ ....... ..... ................ . ..... . .. . ... ..... . ..... ... -M ..... .... ....... . ....... -a ..... ....... .. ....... .......... ....... .. .... ... .......... ......... . W.ri D at .... .. ........ .... . .......... . .............. ............. .. . ....... ... ..... .......... ..... ......... . ...... ..... ..... ... .... ...... ... .......... .111 k:: ................ Fund 170 Interest & Sinking GO Bonds ------ - ---- - TexasDAILY 0.09% AAAm 04/30/2016 49761 41761 100.00 40761 N/A 1 0.09% exE PNexBank pinin 0.45% 02/27/2017 1 P2871232 19287,232 100.00 1 v287,232 N/A 0.45% 7 TexPool 0.09% AAAm 09/30/2015 293062468 29306,468 100.00 293069468 N/A 1 0.09% Sub Total Average Oa22%--- - - - -- - ---- ------ 3 598y461 3,5982461 100000 3,698,461 1 012% Fund 210 a Interest & Sinking Debt Service JpMorgan Chase 0.19%- 09/30/2015 59575 51575 100.00 5t575 N�/A 1 0.19% Sub Total I Average 0,019% 5576 59575 100000 51675 1 0019% Fund 459 in 2018 Bond Fund MINIMUM ---- TexPool 0.09% AAAm 12/15/2018 128Y632 128?632 100.00 1281632 N/A 1 0.09% NOW Sub Total I Average 0009% 128,632 128,632 100800 1289632 11 1 0009% MINIMUM Fund 462 2017 Bond Fund M -------- 110 TexPool 0.09% AAAm 05/30/2017 103,509 1031509 100.00 1039509 N/A 1 0.09% NexBank 0.45% 03/30/2020 11604,471 196040471 100.00 116041471 N/A 1 0.45% Bank OZK k Banl 1.15% 03/06/2020 295219764 275219764 100.00 2,521,764 03/08/2021 67 1.15% E�a st East West Bank 0.33% 10/13/2020 11100,796 19100,796 100.00 19100,796 07/13/2021 194 0.33% FitL Cit Of Austin GO 'a 0.17% Aal /AAA/AAA 10/06/2020 MINE 21200,000 292009000 100.03 21200,616 09/01/2021 244 0.17% E s t' East West Bank 0.26% 12/2112020 61000,470 61000,P470 100.00 610000470 12/21/2021 355 0.26% Sub Total I Average oe44P/o 139531,009 1395319009 100800 139531,625 2251 On"% n4 Fund 466 2019 CO Bond Fund NexE NexBank 0.45% 06/28/2019 99,326 99,326 100.00 0 99,326 N/A 1 0.45% TexF TexPool 0.09% AAAm 09/01/2020 25OP620 250,620 100. 0 25016 20 N/A 1 0.09% Ke it Veritex Community Bank 0.14% 06/19/2020 8v225,305 89225,305 100.00 812259305 N/A 1 0.14% In d�e 1 E Independent Bank 0.60% 06/1912020 100030,434 10,030,434 00 00 100.00 10Y030j434 06/21/2021 172 0.60% Inde endent Bank 0.40% 12/07/2020 810001000 81000,000 100.00 8,0001000 12/07/2021 341 0.40% Sub Total I Average 0*39% 269606,685 26,6069685 100000 26,6059685 168 0,p39% Fund 591 MOReserves Fund Texpool 0.09% AAA 09/30/2015 81721 100.00 81721 N/A 1 0.09% NexBank 0.45% MEMO 04/29/2019 854,679 854,679 100.00 8549679 N/A 1 0.45% Su b T 0 Sub Total I �V-erage Ou45% 863,400 863,400 100000 863,400 1 Oe45% Fu "Now" Fund 592 Convention Center Debt Service nd 592 East West Bank East Wes 0.25% 11/20/2020 19000,288 11000,288 100.00 17000,288 05/20/2021 140 0- 0.25% Fon Sub Total I Average Su b Tota WOMEN 015% 1 9000y288 190009288 100000 1 1000t288 14400 016% Fund 602 interest & Sinking Revenue Elonds Texpool 0.09% AAAm 09/30/2015 19135P561 19135,561 100.00 11135,561 N/A 1 0.09% East West Bank MINIMUM 0.25% 11/20/2020 51001 59001,439 100.00 590011439 05/20/2021 140 0.25% Sub Total I Average 0p,22 % 6t137v000 611379000 100000 69137,000 114 012% '0 Fund 605 Kalahari Debt Service Reserve 11111 MEMO TexPool 0.09% AAArn -- 08/30/2019 340�01 1 340,011 1 100.00 3409011 1 N/A 1 0.09 0 0 Sub Total I Average 0,09% imp ---- 340,9011 3401,011 1008 001 3" Oil 9 1 0009% 0/0 City of Round Rock Page 8. Holdings b Allocation and Portfolio (Fund) uecemoer 4-1 cvcu .. .. ...... ..... . .. ... ..... . ......... . ......... GouponSetu lmmat face'AOUnI Price Days to YTM � UerCredtRafiDateng Bo ValueOrkal a ue Mau at& R4 eMaduity.... hook... .... .. .. .... Fund 863 •Drainage Utility Revenue Bond NexBank 0.45% O8I30/2020 2679025 267,025 100.00 267,025 N/A 1 0.45% TexP001 0.09% AAAm 10/31/2015 6939862 693,862 100.00 693,862 N/A 1 0.09% Sub Total Average 0.19% 9609887 96098871f 100800 960p887 1 0819%.................................... Totalge1.23Yo93'4''Not -LLL I �I -2 68Q I -- ---------195 0....... OIWO .......................... S.3 171 -I Y7 646-UK: . ..... .... ... .... ' 1.06Y. City of Round Rock Page 9. Valley View Consulting, L.L.C. Book Value Comparison December 31, 2020 -- ----- --- - - ----------------- - --- --- --- --- --- ------ --- ---- ------- .... ... . ... . ... . . .... .. .... . ........ .. I .. . ........Coupon Issuer. . . . . ... ... . - - ----- ----- Rate ----- --------- ------------------------ Setllement �Aatu�ity Date.... ..... .... Date ......... ..... ..... ------------------- ----- ---- ng. .... eogk egin.. .ni..... B...... Value ... .. . ------ Total.. 3...uy.. / Increases .. s.. 11.. sJ Tota.......1.........U..................... Dec►easss ..*... ........... .. . . ----------------------------------- g Book End.. .... in.*..r. Yalus ..... .......... . . ..... �hanae 16:.800k ... .. ......................................... Value ........ Fund 000 -Pooled Investments Jp-Morgan Chase N/A 09/30/2015 N/A-- $ 50801,132 $ 2160955 $ 728,748 $ 592899338 $ (511,793 TexP001 N/A 09/30/2015 N/A 9162%907 2796361616 716870027 2995791495 19,9499589 TexSTAR N/A 09/30/2015 N/A 200t452 47 2009499 47 TexasDAILY NIA 09/30/2015 N/A 3tOO21274 422 21000,000 7,002 696 1,999,578 NexBank N/A 11/29/2016 N/A 29,1439556 6t680,663 351824,219 W W 6,680,663 Veritex Community Bank N/A 09/01/2020 N/A 5t946tO57 2p533 5194 895 91 215 3 3 East West Bank 2.78% 01/11/2019 10/12/2020 4Y1969286 41196t286 (41196,286 FHLB 2.86% 10/02/2018 10/15/2020 5199%985 690OOtOOO (5?999,985 Independent Bank 2.65% 05/01/2019 11/01/2020 59341,022 359578 5t376,599(513411022 ProsperityBank 3.05% 11/16/2018 11/16/2020 5t287,228 13,218 523001446(50287,228) Bank OZK 1.72% 02/14/2020 11/16/2020 5,050,908 71145 5vO58,052(570509908 East West Bank 2.70% 02/20/2019 11/20/2020 51222,656 111990 51234,646 (5t222,656 Inde endent Bank 2.05% 09/03/2019 12/03/2020 390629024 310629024(39062,024 ProsperityBank 3.05% 12/07/2018 12/07/2020 51274,017 26,844 59300,861(5t274tO17) Inde endent Bank 1.85% 10/04/2019 01/04/2021 59069,631 23,575 51093Y206 239575 East West Bank 2.78% 01/11/2019 01/11/2021 10,490,716 731765 10,5640481 739765 Origin Bank 2.82% 02/12/2019 02/12/2021 69466,678 45,965 615129643 457965 Carrollton Farmers Branch GO 5.100% 04/09/2020 02/15/2021 2,9749309 299442770 2-91539) Cedar Hill ISD Ref-TxbF0600% 11/14/2019 02/15/2021 4969419 498,806 29387 Goose Creek ISD 5.00% 11/17/2020 02/15/2021 5051755 502,941 502,941 East West Bank 2.71% 02I20/2019 02/19/2021 10,969,348 751182 1190449530 75V182 FORT BEND COUNTY -REF 5.00% 06/17/2020 03/01/2021 2549281 2519690(2,591) ProsperityBank 2.74% 03/01/2019 03/01/2021 296059126 171788 2,6229914 177788 Indeeendent Bank 1.86% 09/30/2019 03/30/2021 5,0939716 23,556 591170273 23,556 Independent Ba;�k 1.80% 10/11/2019 04/12/2021 911211925 411273 991639198 419273 Independent bank 2415% 07/22/2019 04/22/2021 511089503 271608 5Y1369111 27,608 Allegiance Bank 1.70% 02/10/2020 05/10/2021 510429357 219547 50063,904 211547 Independent Bank 0.65% 05/16/2020 05/17/2021 592089334 81533 5,2169867 81533 BBVA 1.94% 08/27/2019 05/27/2021 51106t423 249690 511319113 249690 Bexar CountyFlood GO Ref 5.00% 04/07/2020 06/15/2021 310091983 21981,462 (28,521) Veritex CommunityBank 1.67% 12/20/2019 06/21/2021 5,0639175 21,081 51084,256 219081 BOKF, NA 2.00% 06/27/2019 06/24/2021 210009000 21000,000 Veritex CommunityBank 1.74% 09/30/2019 06/30/2021 57087,811 221071 51109,882 229071 BBVA 1.77% 10/03/2019 07/05/2021 590817736 22Y349 51104,085 22,349 Inde endent Bank 2.15% 07/22/2019 07122/2021 591080503 279608 5Y13691 11 279608 R Bank 1.80% 01/27/2020 07/27/2021 210187031 91176 210270207 91176 Denton ISD 0.00% 12/17/2020 08/15/2021 4981970 499,030 4997030 East West Bank 1.64% 11/22/2019 08/23/2021 52071,041 219005 51092,046 21,005 State of TX Transportation 4.00% 09/02/2020 08/26/2021 91309,776 99223,414(861362) BBVA 1.87% 08/27/2019 08/27/2021 3,061,527 14,267 39075,794 14,267 SecurityState Bank & Trust 2.09% 09/05/2019 09/13/2021 79147,475 379117 Z184v592 379117 Veritex CommunityBank 1.71% 10/03/2019 10/04/2021 10 128,917 43,657 1091721574 431657 East West Bank 1.65% 01/27/2020 10/27/2021 670672643 259287 6YO929929 257287 EastWestBank 1.54% 02/18/2020 11/19/2021 67057,485 231558 69081,043 23,558 East West Bank 1.64% 11/22/2019 11/22/2021 51071,041 219005 59092,046 211005 Independent Bank 0.40% 12/07/2020 12/07/2021 8,0001000 89000,000 8 000 000 VeritexCommunit Bank 1.67% 12/20/2019 12/20/2021 57063,175 219081 590849256 21,081 Bank OZK 1.70% 01l28I2020 01/24/2022 8PO91,422 34,363 89125,785 34,363 R Bank 1.75% 01/27/2020 01/27/2022 290179528 81919 210269447 879,19 Allegiance Bank 1.59% 02/10/2020 02/10/2022 59039,611 20,142 510599753 209142 Goose Creek ISD 5.00% 11/17/2020 02/15/2022 4239160 420,920 420,920 East West Bank 1.54% 02/18/2020 02/18/2022 59047,904 199632 50067536 199632 FORT BEND COUNTY -REF 5.00% 06/17/2020 03/01/2022 264,116 2619604(29512 Allegiance Bank 0.40% 06/17/2020 03/18/2022 109009,863 9?982 10,0199845 91982 Allegiance Bank 0.45% 06/17/2020 06/17/2022 129013,315 130478 120026,793 13,478 Bank OZK 0.50% 07/09/2020 07/11/2022 109008,495 12,482 10,020,976 129482 City of Bryan TX 0.45% 11/19/2020 08/15/2022 5009000 5009000 500,0001 City of Round Rock Page 10. Valley View Consulting, L.L.C. Book Value Comparison December 31 a 2020 - - - - - - - - - - - - - - - - - - - - . ... .... ... s ue.r . ... .... . ... J s -R e m 0. e ... ... -Maturi .-Date .m nt'' ...... .... ... ......... .... . ........ .......... .. nn- Ing o.k:, -So . .... ..... . V, ... ........... .............. .... .... . .... . .... ... W, S. t .1a .... MY-—— .. . . . . ............ ................ ...... .. Total. . . ........ .. ............ .. ..... din,: wa.k -En -'S . ..... . ..... ... g. 0: ..... .. ............ .... .... .. Chan ...... . ........... 'In-8 '''k ...... ..... ..... ... Denton ISD 0.00% 12/17/2020 08/15/2022 4960180 4960268 496,268 Cit of Austin GO 0.27% 10/06/2020 09/01/2022 7009000 700tOOO 700,000 Prospedty Bank 0.40% 10/15/2020 10/17/2022 69004,001 610040001 610049001 Bank OZK 0.28% 12/07/2020 12/07/2022 51000,000 51000,000 51000,000 Sub Total/Average Fund 000 Pooled Inves ents 30490049842 679571,1818 49v9"0690 31194799942 794769100 Fund 170 - Interest & Sinking GO Bonds TexPool N/A 09/30/2015 N/A 94,265 212120203 293069468 212122203 TexasDAILY N/A 04/30/2016 N/A 41759 1 4,761 1 NexBank --"I N/A 02/27/2017 N/A 1,8332090 11459 547,317 7] 19287,232 (545,858) Sub Total/lAverage Fund 170 =interest& Sinking GO Bonds M i Is9329114 29213v663 7 6479317 39598,461 11666,346 Fund 210 Interest & Sinking Debt Service ipmagan Chase N/A 09/30/2015 N/A 750 59575 75 0 Sub TotalVAverape Fund 210 Interest & Sinking Debt Service ��4,825 4t825 0 750__ 59575 750 Fund 459 2018 Bond Fund TexPool N/A 12/15/2018 N/A 15199670 73 �311111 1281632 (31,038)1 Sub Total/Average F"und 459 2018 Bond Fund 73 319111 1289632 (3190381 Fund 462 2017 Bond Fund TexPool N/A 05/30/2017 N/A 39386,397 103,534 31386,422 103,509 : 509 (3,2829 NexBank N/A 03/30/2020 N/A 21169,287 21177 566,993 4:71 11604,471 (564,816) Southside Bank 1.70% 12/19/2019 12/21/2020 61077,178 610779178 (6,077,178) Bank OZK 1.15% 03/08/2021 215149541 71223 295219764 71223 East West Bank 0.33% 103/06/2020 10/13/2020 07/13/2021 191009796 11100,796 111009796 City of Austin GO 0.17% 10/06/2020 09/01/2021 21200,000 21200v000 21200,000 East West Bank 0.26-% 12/21/2020 U2/21/2021 61000,470 67000,1470 690001470 Sub Total/Average Fund 462m 2017 Bond Fund 1491479403 91414,199 10,0309593 139531,009 16j3 U4 Fund 465 m 2019 CO Bond Fund TexP001 - N/A 09/01/2020 N/A 250,547 73 25OP620 73 NexBank N/A 06/28/2019 N/A 5,624,913 21225 51527,812 9199326 (505:25587) Vedtex Community Bank N/A 06/19/2020 N/A 127066,812 �4,660 31846,167 812251305 (398411507) Indeeendent Bank 2.52% 06/05/2019 12/05/2020 411271901 491279901 (41.1279901) Independent Bank 0.60% 06/19/2020 06/21/2021 101015,452 140982 10,0309434 14,982 Inde endent Bank 122.ej2 0.40% 12/07/2020 12/07/2021 890009000 81000,000 81000,000 Sub Total/Average Fund 465 2019 CO Bond Fund 329O85p625 89021,939 1396019880 -1� 26,605,685 1(5,4799940) Fund 591 Reserves Fund TexPool N/A 09/30/2015 N/A 8,718 2 8,721 2 NexBank N/A 04/29/2019 N/A 853,711 969 8547679 969 Sub Total/Average Fund 591 Reserves Fund 8629429 971 11639400 971 Fund 692 Convention Center Debt Service East West Bank 0.25% 11/20/2020 05/20/2021 19000,288 19000,288 110001288 Sub Total/Average Fund 592 Convention Center Debt Service I t0009288 1 1000p288 900 v2 Fund 602 Interest & Sinking Revenue Bonds TexPool N/A 09/30/2015 N/A 112719850 462 136,751 111359561 (136,289) East West Bank 0.25% 11/20/2020 '65'/20/2021 2 q1 51001,439 510010439 5,0012439 Now" Sub Total/Average Fund 602 Interest & Sinking Revenue Bonds 51001,901 136g761 69.137,000 418.65j150 Fund 605 = Kalahari Debt Service Reserve 1192719850 Texpool -M N/A 08/30/2019 N/A 984,330 179 644?499 340,011 (644,319 Sub Total/Average Fund 605 Kalahari Debt Service Reserve 984,3301 1791 6"9499 340,011 (6"1319) City of Round Rock Page o V'..``.'..'..'`'.`` Book Value Comparison December 31, 2020 --------- - --- -- iilka .....T t� _ Ending:. Bc�� 0 ��... . .............an e in:: 8+�. . ..... ....... .............. Cou n ,et................ tiemen� _ �nn� Book .......... ...... ....._ T.................. o# Bu �l. ...... :' Q. _ t ll�t__......... ...... ....i�at+e _ Qa#e.... .......... ;. :...:. ... Value:... ... ............. Issuer - atu ::. ,, .�n� ases.. De�rea�es ��...... ue ` v.... alue ... Fund 863 -Drainage Utility Revenue Bond TexPool NIA 10/31/2015 N/A 229,769 546,853 82,760 6930862 4641093 NexBank-- NIA 08/30/2020 N/A 267,127 303 404 2679025(101 Bank OZK 0.58% 05/01/2020 il/02/2'020 7519828 383 7521211(751,828) 863 - Drainage UtilityRevenue Bond Sub Total/Average F. 1924897241W.M.- 547v5391 835,376 960p88771 ... .................und .. .... ... . . . ................... otal7Average- T . .......... . .... . ... ........ ................. ............. ............................................. ........................... .... .... ..... . .... $ 356 7018'f3 ... .. ........ . ... 321 83 7T3,.. ;........ 7547-2:217:..... . ...... . ......... . .............. . .... ......(287,8371 S 364,850.88Q- ............ ...... City of Round Rock Page 12. Valley View Consulting, L.L.C. Market Value Comparison December 31, 2020 issues.. ....... .. ...... . .... ......... ke. . . Coupon Settlement B..eginni., a......... r...... .. ng M....arket .. Total Buys! Totat .... .....Ballet End.. in.... g Market C... . .... ... ... ha.. ....... ate 1/alue increas+�s Decreases ltalus Yalus... . .... ... ... y R.. . n... . .... g.......e I.......I n M.. Rate Date matur. . ...............it........ ....... .......... ........ . ..... ... . . . . ..... ... ...... .. .... .. ........... ... ......... . . ......... .. .... ..... ........ . .. . .. ....... ... ... ... . ........ . ...... Fund 000 -Pooled Investments JPMorgan Chase N/A 09/30/2015 NIA $ 508019132 $ 2169955 $ 728,748 $ 592899338 $ TexPool N/A 09/30/2015 NIA 9',629,907 27,6369616 716870027 299579,495 TexSTAR N/A 09/30/2015 N/A 2009452 47 2009499 TexasDAILY N/A 09/30/2015 N/A 390029274 422 290009000 110021696 NexBank ---MON a N/A 11/29/2016 N/A 299143,556 61680,663 3578249219 Veritex Community Bank N/A 09/01/2020- N/A 51946,057 21533 529481591 East West Bank 2.78% 01/11/2019 10112/2020 491969286 491969286 FHLB 2.86% 10/02/2018 10/15/2020 6,0067319 69000,000 (69319 Independent Bank 2.65% 05/01/2019 11/01/2020 593419022 35 578 59376Y599 Prosperity Bank 3.05% 11/1612018 11/16/2020 522877228 130218 59300,446 Bank OZK 1.72% 02/14/2020 11/16/2020 51050,908 79145 51058,052 East West Bank 2.70% 02/20/2019 11/20/2020 5t222,656 11,990 5 234 646 Indeeendent Bank 2.05% 09/03/2019 12/03/2020 390620024 31062,024 Pros aril Bank 3.05% 12/07/2018 12/07/2020 51274,017 26,844 51300,861 Independent Bank 1.85% 10/04/2019 01/04/2021 5,069,631 231575 51093t2O6 East West Bank 2.78% 01l11/2019 01/11/2021 101490,716 73,765 1015649481 Od in Bank 2.82% 02/12/2019 02/12/2021 694661678 457965 615129643 Carrollton Farmers Branch GO 5.00% 04/09/2020 02/15/2021 219829681 239459969 (36,713 Cedar Hill ISD Ref-Txbl 0.00% 11/14/2019 02/15/2021 4979825 4999640 17815 Goose Creek ISD 5.00% 11/17/2020 02/15/2021 505,755 5029655 3,100 East West Bank 2.71% 02/20/2019 02/19/2021 10,969,348 75,182 1110441530 FORT BEND COUNTY -REF 5.00% 06/17/2020 03/01/2021 254,628 2510853 (27775 Proseerity Bank 2.74% 03/01/2019 03/01l2021 29605,126 17,788 2,6229914 Independent Bank 1.86% 09/30/20119 03/30/2021 50093,716 231556 51117,273 Inde endent Bank 1.80% 10111/2019 04/12/2021 991219925 419273 9,163,198 IndeEendent Bank 2.15% 07/22/2019 04/22/2021 51108,503 27Y608 511369111 Alle lance Bank 1.70% 02/10/2020 05/10/2021 5Y0421357 211547 5,063,904 Independent Bank 0.65%* 05/16/2020 05/17/2021 59208t334 81533 59216,867 BBVA 1.94% 08/27/2019 05/27/2021 51106,423 24,690 591319113 Bexar County Flood GO Ref 5.00% 04/07/2020 06/15/2021 3tWOP206 21993,3 Veritex Community Bank 1.67% 12/20/2019 06/21/2021 5,063,175 21,081 51084,256 BOKF, NA 2.00% 06/27l2019 06/24l2021 270001000 290009000 Veritex Community Bank 1.74% OF/30/2019 06/70RN21 590879811 221071 59109,882 BBVA 1.77% 10/03/2019 07/05/2021 51081,736 22?349 5,104,085 Independent Bank 2.15% 07/22/2019 07/22/2021 5,108,503 27Y608 511369111 R Bank 1.80% 01/27/2020 07/27/2021 21018,031 91176 210279207 Denton ISD 0.00% 12/17/2020 08/15/2021 498,970 499,070 100 East West Bank 1.64% 11/22/2019 08/23/2021 510719041 21,005 5,0927046 State of TX Transportation 4.00% 9/02/2020 08/26/2021 993089340 91224,280 (84,0621 BBVA 1.87% 08/27/2019 08/27/2021 3,0611527 14,267 31075,794 Security State Bank & Trust 2.09% 09/05/2019 09/13/2021 711479475 379117 71184,592 Veritex CommunitBank 1.71% 10/0 3/20 19 10/04/2021� 10,128,917 431657 1011729574 East West Bank 1.65% 01/27/2020 10/27/2021 69067,643 259287 6,092,929 East West Bank 1.54% 02/18/2020 11/19/2021 690570485 239558 610819043 East West Bank 1.64% 11/22/2019 11/22/2021 59071,041 21,005 510929046 Independent Bank 0.40% 12l07/2020 12/0772021 8,000 000 8,000 000 Veritex Community_Bank 1.67% 12/20/2019 12/20/2021 59063,175 219081 59084,256 Bank OZK 1.70% 01/28/2020 01/24/2022 89091,422 341363 871259785 R Bank 1.75% 01/27I20 01/27/2022 290179528 81919 2,026,447 Allegiance Bank 1.59%02/10/2020 02/10/2022 51039,611 209142 500599753 Goose Creek ISD 5.00% 11/17/2020 02J1 5/2022 423,160 4209904 (21256 East West Bank 1,54% 02/18/2020 02/18/2022 51047,904 19,632 5,067,536 FORT BEND COUNTY -REF 5.00% 06/17/2020 03/01/2022 2659480 2639793.. Q9688 Allegiance Bank 0840% 06/17/2020 03/18/2022-- 1090099863 99982 1010199845 Meglance Bank 0.45% 06/17/2020 06/17/2022 12 013 315 137478 12,0267793 Bank OZK 0.50% 07/09/2020 07/11/2022 1OP008v495 129482 10,0201976 City of Bry an TX 0.45% 11/19/2020 08/15/2022 5007000 5009845 845 Uty or Kouna KocK Page 13. Valley View Consulting, L.L.C. Market Value Comparison December 31, 2020 Issue� .... .. .. Coupon Rats Sedleme� Date Maturity Gate... 8eginninq Market Val Total Buysl Increases Total Sells! pecreates En. . ding Market Value go..in ...a... . . .. Value Denton ISD 0.00%1 12/17/2020 08/15/2022 - 496,180 - 4969925 745 City of Austin GO 01.27% 10I06/2020 09/01/2022 7001000 7019218 19218 Prosperity Bank 0.40% 10/15/2020 10/17/2022 61004,001 6,0049001 Bank OZK 0.28% 12/07/2020 12/07/2022 51000,000 50000,000 Sub Total/Average Fund 000 -Pooled Investments 304,0419463 5795719818 49,944,690 3119499,563 (169v018 Fund 170 - Interest 8 Sinking GO Bonds TexPool N/A 09/30/2015 N/A 949265 29212,203 21306,468 TexasDAILY N/A 04/30/2016 NIA 4,759 1 49761 NexBank NIA 02/27/2017 NIA 1,833,090 11459 5479317 112879232 Sub Total/Averase Fund 170 -Interest 8 SinkingGO Bonds 19932,114 2,213,663 647j31.7 315989461 Fund 210 - Interest 8 Sinking Debt Service ipmorgan Chase N/A 09/30/2015 NIA 4,825 750 5,575 Sub Total/Average Fund 210 -Interest & SinkingDebt Service 49825 750 59575 Fund 469 - 2018 Bond Fund - - - ------- TexPool N/A 12/15/2018 N/A 1590670 73 319111 128P632 Sub Total/Average Fund 459 - 2018 Bond Fund 1599670 73 31j111 128t632 Fund 462 - 2017 Bond Fund TexPool N/A 05/30/2017 N/A 393861397 1039534 39386,422 1039509 NexBank NIA 03/30/2020 N/A 21169,287 21177 566,993 1,604,471 Now Southside Bank 1.70% 12/19/2019 12/21/2020 61077,178 690777178 Bank OZK 1.15% 03/06/2020 03/08/2021 21514,541 71223 2,5217764 East West Bank 0.33% 10/13/2020 07/13/2021 11100,796 19100,796 Cityof Austin GO 0.17% 10/06/2020 09/01/2021 212009000 29200,616 616 East West Bank 0.26% 12/21/2020 _p 12/21/2021 610009470 690009470 Sub Total/Average Fund 462 - 2017 Bond Fund W i NO W 149147t4O3 91414,199 1OpO309593 1395319625 616 Fund 465 - 2019 CO Bond Fund TexPool N/A 09/01/2020 N/A 250,547 73 250,620 NexBank N/A 06/28/2019 N/A 576249913 2t225 59527?812 99,326 Veritex CommunityBank NIA 06/19/2020 N/A 121066,812 4,660 318461167 8t2251305 Independent Bank 2.52% 06/OS/2019 12/OS/2020 4,127,901 4,127,901 Independent Bank 0.60% 06119/2020 06/21/2021 10,0159452 14,982 10,030,434 Independent Bank 0.40% 12/07/2020 12/07/2021 8t000,000 810009000 Sub Total/Average Fund 465 - 2019 CO Bond Fund 329085j626 890219939 1395019880 26y6069685 Fund 591 •Reserves Fund TexPool WA 09/30/2015 N/A 89718 2 81721 NexBank WA 04/29/2019 N/A 853,711 969 8549679 Sub Total/Average Fund 591 -Reserves Fund 8629429 971 8639400 Fund 592 -Convention Center Debt Service East West Bank 0.25% 11/20./2020, 05/20/2021 17000,288 1 110009288 Sub Total/Average Fund 592 -Convention Center Debt Service 1900092 88 190009288 Fund 602 •Interest 8 Sinking Revenue Bonds TexPool N/A 09/30/2015 N/A 1,2719850 462 1369751 191359561 East West Bank 0.25% 11/20/2020 F5'/20/2021 5,001 1439 51001,439 Sub Total/Average FunaiE -Interest 8 SinkingRevenue Bonds 19271,850 5,0019901 1369751_ 691379000 Fund 605 -Kalahari Debt Service Reserve TexPool NIA 08/30/2019 N/A 984,330 I 179 644,499 3409011 Total/Average Fund 605 -Kalahari Debt Service Reserve 984 330 -Sub 179 644 499 340,011 City of Round Rock Valley View Consulting, L.L.C. Page 14. AAarket Value Comparison December 31, 2020 ............ - ---------- .... .. .:In Mar. .... .. n:Settleme�# �nnin AAA rket T u: _ . �etl� ;; Endi M:ark+�# ' Cha�� e_ �t ou _ __ B. _ a :.:: __ _oil! �., .... _. Tom# _!_ _ . _ :. _ t►g' _ . _ _ __ gRQ .issuer -CM��ur Date,.: V � r� D - c 1t�tue . , > . Val'ue Rate .. �at� _ . ague _ _ t. +� _,ales +�c eat... ....... Fund 863 - Drainage Utility Revenue Bond TexPool NIA 10/31I2015 N/A 229,769 5461853 82,760 6931862 - NexBank N/A 08/30/2020 N/A 267,127 303 404 267,025 Bank OZK 0.58% 05/01/2020 11/02I2020 7519828 383 752,211 Sub TotaliAverage Fund 863 - Drainage UtilityRevenue Bo..... 1p2489724W 6479539.. 9359376 960,887 - ..... .... ....nd Total] Avera e....... .. ..... .......... ......... ....... .......... W.... ..... 356 738y24 S . ... .. 83 773 327 75 672:217: S 364 671 127 . $(168�402 City of Round Rock Page 15. Valley View Consulting, L.L.C. Holdings by Allocation and Portfolio (Fund) September 30, 2020 .. . ...... . C: OUPQ. suer.. .. . .... .. . ... . .... ...... . M2 .. ..... ... .. . . C redit. RaUng ... . . ........ . . ....... . ..... ......... .. ....... ........ . . . ... ........ .. em en tu t ......... .. ... . . ....... D. .. ...... ..... . . . . ... ..... ... ... ............... ... .................. .... "Fa A me moun I .. ...... .. .. ...... ..... . ...... 4TO ......... Mirk fto-k Voil .............. t . . ..... .... . .. ..... ... .... .... ... -P r .. -':M ket-Valu ..... Sir. ....... .... ..... ....... .. . ... . .......... .. ...... ...... ...... ':M:at.0 n Dat ..... .. ... ... ..... .... . . 42tu ....... ...... M Boo ......... .. Fund 000 Pooled Investments NexBank 0.45% 11/29/2016 $ 2991430556 $ 299143,556 100.00 $ 29,1439556 N/A 1 0.45% Vedtex Community Bank 0.20% 09/01/2020 51946,057 51946,057 100.00 519469057 1 0.20% ipmo[gan Chase 0.17%-- 59/30/2015 5,8019132 59801,132 100.00 598019132 1 0.17% TexSTAR 0.13% 09/30/2015 2009452 2009452 --- -- --- 100.00 2009452 ---N/A N/A 1 0.13% TexPool 0.15% 1AAAm AAAm 09/30/2015 9t6299907 916299907 100.00 99629,907 N/A 1 0.15% TexasDAILY 0.14% AAAm 09/30/2015 31002,274 390020274 100.00 31002,274 N/A 1 0.14% East West Bank 2.78% 01/11/2019 491969286 491969286 100.00 49196,286 10/12/2020 12 2.78% FHLB 2.86% Aaa/AA+/- 61000,000 100.11 69006,319 10/15/2020 15 2.87% Independent Bank 2.65% 110/02/2018 05/01/2019 593419022 15,9999985 593419022 100.00 513419022 11/01/2020 32 2.65% Prosperity Bank 3.05% 11/16/2018 51287t228 59287t228 100.00 572879228 11/16/2020 47 3.05% Bank OZK 1.72% 02/14/2020 59050,908 1100.00 57050,908 11/16/2020 47 1.721% East West Bank r a t 2.70% 02/20/2019 15,050,908 512221656 100.00 51222,656 11/20/2020 51 2. 70% Independent Bank 1n d�e i 2.05% 09/03/2019 IIIIIIIIIIIIIIWIIIIIIII�51222,656 390627024 39062,024 100.00 31062,024 12/03/2020 64 2.05% ros Prosperity Bank 3.05% 12/07/2018 59274,017 51274,017 100.00 512740017 12/07/2020 68 3.05% Inde Inde endent Bank r ja 1.85% 10/04/2019 51069,631 50691631 100.00 5YO69P631 01/04/2021 96 1.85% st I East West Bank E 2.78% 01/11/2019 1 Ot490,716 10,490,716 100.00 10,4909716 01/11/2021 103 2.78% Ori in Bank 2.82% 02/12/2019 694669678 694669678 100.00 69466,678 02/12/2021 135 2.82% Cedar Hill ISD Ref,-Txbl 0.00% Aaa/-/AAA 11/14/2019 5009000 496,419 99.57 4979825 02/15/2021 138 1.93% Carrollton Farmers Branch GO 5.00% Aaa/AAA/- 04/09/2020 299309000 279741309 101.80 299829681 02/15/2021 138 0.95% East West Bank 2.71% 02/20/2019 10,969,348 10,969,348 100.00 100969,348 02/19/2021 142 2.71% FORT BEND COUNTY -REF 5.00% Aal/-/AA+ 06/17/2020 2501000 254,281 101.85 2549628 03/01/2021 152 0.87% Prosperity Bank 2.74% 03/01/2019 29605,126 21605,126 1 00.00r 27605P 126 0-3/01/2021 152 2.74% Independent Bank 1.86% 09/30/2019 51093,716 51093,716 100.00 590939716 03/30/2021 181 1.86% nde Inde endent Bank 1.80% 10/11/2019 91121 v925 991219925 100.00 911219925 04/12/2021 1194 1.80% Inde endent Bank nde 2.15% 07/22/2019 5 t 1080503 511089503 100.00 511089503 04/22/2021 204 2.15% Allecli Allegiance Bank 1.70% 02/10/2020 59042,357 510429357 100.00 5-,042,357 05/10/2021 222 1.70% 'nde Inde ndent Bank 0.65% 05/16/2020 592089334 59208Y334 100.00 512089334 05/17/2021 229 0.65% A BBVA 1.94% 08/27/2019 571069423 51106t423 100.00 511061423 05/27/2021 2*ji7 1.94% rBB Bexar County Flood GO Ref Bexarl 5.00% Aaa/AAA/AAA 04/07/2020 219301000 31009,983 103.42 31030,206 06/15/2021 258 1.10% Veritex Veritex Community Bank 1.67% 12/20/2019 510639175 51063,175 100.00 510639175 06/21/2021 264 1.67% BOKF, 2.00% 06/27/2019 290007000 29000,000 100.00 21000,000 06/24/2021 267 2.00% kBOK Veritex Community Bank Verit 1.74% 09/30/20-19 57087?811 ----1 51087,811 1100.00 570871811 06/30/2021 273 1.74% BBVA 1.77% 10/03/2019 570819736 510819736 100.00 510819736 07/05/2021 278 1.77% In Inde endent Bank 2.15% 07/22/2019 591089503 5,1089503 100.00 51108Y�03 07/22/2021 295 2.15% R Bank Bar 1.80% 01/27/2020 21018,031 290189031 100.00 22018,031 07/27/2021 300 1.80% East West Bank East I 1.64% 11/22/2019 510711041 51071,041 100.00 08/23/2021 327 1.64% State of TX Transportation State 4.00% MlGl/SP1+/Fl+ 09/02/2020 91309,776 103.43 9v3081340 08/26/2021 330 0.20% BBVA BBV 1.87% 08/27/2019 11111111111111111111111990001000 39061,527 39061,527 100.00 390610527 08/27/2021 331 1.87% Security State Bank & Trust SeCL 2.09%- 71147,475 79147,475 00.00 77147,475 09/13/2021 348 2.09% Veritex Community Bank Verit 1.71% 109/05/2019 10/03/2019 1091289917 10,128,917 100.00 1091281917 10/04/2021 369 1 471% ast East West Bank [EEast 1.65% 01/27/2020 690679643 61067,643 .100.00 60067,643 10/27/2021 392 1.65% East West Bank 1.54% 02/18/2020 61057,485 61057,485 100.00 61057,485 11/19/2021 415 1.54% East West Bank as t 1.64% 11/22/2019 5YO71,041 590710041 100.00 510719041 11/22/2021 418 1.64% Veritex Community Bank e rit 1.67% 12/20/2019 59063,175 59063gl75 100.00 510631175 12/20/2021 446 1.67% Bani Bank OZK 1.70% 01/28/2020 890910422 890919422 100.00 870919422 01/24/2022 481 1.70% R Bc R Bank 1.75% 01/27/2020 21017,528 21017,528 100.00 20017,528 01/27/2022 484 1.75% Alle iance Bank 02/10/2020 590399611 5039961 1 100.00111 510397611 02/10/2022 498 1.59% East West Bank -1.59% .754% 02/18/2070 51047f904 59047,904 100.00 51047,904 02/18/2022 506 1.54% FORT BEND COUNTY -REF 5.00% Aal/-/AA+ 06/17/2020 250,000 264,116 106.19 2651480 03/01/2022 517 0.98% Alle iance Bank 0.40% 06/17/2020 10,0091863 1 OvOO91863 100.00 1101009,863 03/18/2022 534 0.40% Alle iance Bank 1 0.45% 06/17/2020 12?0131315 129013,315 1 100.00 1290139315 06/17/2022 625 0.45% Bank OZK 0.50% 07/09/2020 10,008,495 1010080495 100.001 10,008,495 07/11/2022 649 0.50% Sub Total Average 1s70% 3039555,973 304jO049842 1 100016 3049041,453 237 1051% City of Round Rock Page 16. Holdings by Allocation and Portfolio (Fund) September 30, ZUZU .. .... .............. ........... ...... ............... :.co .. ....... .. .issues Rate' Credit Rating Settement Dane ... Face A-mountl Shares Market Book Valus Price Market Value ... .... Maturity Date ays W Mau D.... YTM � ao................. Fund 170 -Interest 8 Sinking GO Bonds TexasDAILY 0.14% AAAm 04/30/2016 41759 41759 100.00 4,759 N/A 1 0.14% NexBank 0.45% 02/27/2017 108339090 1p833909 100.00 1,8339090 N/A 1 0.45% TexPool 0.15% AAAm 09I30/2015 94,265 94,265 100.00 949265 N/A 1 0.15% Sub Total I Average OMM43% 119329114 19932,114 100.00 1,932,114 1 0MM43% Fund 210 -Interest 8 Sinking Debt Service JpMorgan Chase 0.17% 09/30/2015 49825 40825 100.00 41825 N_/A 1 0.17% Sub Total I Average 0,17% 4825 49825 100.00 41825 1 0o17% Fund 459 - 2018 Bond Fund TexPool 0.15% AAAm 12/15/2018 159,670 159,670 100.00 1599670 N/A 1 0.15% Sub Total / Average 0.15% 159,670 1599670 100.00 7589670 1 0016% Fund 462 - 2017 Bond Fund TexPool 0.15% AAAm 05/30/2017 373869397 39386,397 100.00 3,386,397 N/A 1 0.15% NexBank 0.45% 03/30/2020 211699287 2,169,287 100.00 291699287 N/A 1 0.45% Southside Bank 1.70°h 12/19/2019 6,0779178 61077,178 100.00 61077p 178 12121/2020 82 1.70% Bank OZK 1.15% 03I06/2020 215149541 275149541 100.00 21514,541 03/08I2021 159 1.15% Sub Total / Average 1o04% 149147p4O3 14j1471403 100.00 149147p4O3 64 IMM04% NOMINEE Fund 465 - 2019 CO Bond Fund NexBank 0.45% 06/28/2019 516249913 51624,913 100.00 516242913 N/A 1 0.45% TexPool 0.15% AAAm 09/01/2020 2509547 2501547 100.00 250,547 N/A 1 0.15% Veritex CommunityBank 0.20% 06/19/2020 129066Y812 12,066,812 100.00 12,06618-12 N/A 1 0.20% Inde endent Bank 2.52% 06/05/2019 411279901 491279901 100.00 411279901 12/05/2020 66 2.52% Independent Bank 0.60% 06I19/2020 1090159452 10,015,452 100.00 101015 452 06/21/2021 264 0.60% Sub Total I Average Oo67% 32yO85p625 329085p626 100000 329086j625 91 0m67% Fund 591 -Reserves Fund TexPool 0.15% AAAm 09/30/2015 8,718 89718 100.00 89718 N/A 1 0.15% NexBank 0.45% 04279/2019 853 711 853,711 100.00 853 711 N/A' 1 0.45% Sub Total I Average 0.45% 862,429 862429 100.00 862142917 0m45% Fund 602 - Interest & Sinking Revenue Bonds TexPool 0.15% AAAm 09/30/2Mo- -015IN _1101pil 11271,850 11271 t850 100.00 112710850 N/A 1 0.15% Sub Total I Average_.-- 0.15% Now 10271,850 19271,850 100.00 10271,850 1 0015% Fund 605 -Kalahari Debt Service Reserve TexPool 0.15% AAAm 08/30/2019 9849330 9849330 100.00 984,330 NIA 1 0.15% Sub Total I Average -in 0.15% 9841330 984,330 100.00 984,330 1 01115% Fund 863 -Drainage Utility Revenue Bond NexBank 0.45% 08/30/2020r 267,127 2679127 100.00 267,127 N/A 1 0.45% TexPool 0.15% AAAm 10/31/2015 229,769 2291769 100.00 2291769 NIA 1 0.15% Bank OZK 0.58% 05/01/2020 751,828 7519828 100.00 751 ,828 11/02/2020 33 0.58% Sub Total /Average in= OMM47% 192489724 1;2489724 100.00 19248,724 201 OMM47% Avg.► 6 1.56°!a....... ...... . .... ............Total-, $ 3-56*2521 W... $ 356 TU4 813 9QQ......... . .. .....14 $ 356 738 424 ............ .. ........ .. .. ..... .... ... ......... 213____ 1.MIN City of Round Rock Page 17. Valley View Consulting, L.L.C.