Loading...
BCRUA_R-21-07-28-5A RESOLUTION NO. R-21-07-28-5A 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 March 31, 2021 for the Brushy Creek Regional Utility Authority ("BCRUA") has been submitted to the Board of Directors; and WHEREAS, the Board of Directors desires to acknowledge the receipt and acceptance of the attached BCRUA Quarterly Investment Report, Now Therefore BE IT RESOLVED BY THE BOARD OF DIRECTORS OF THE BRUSHY CREEK REGIONAL UTILITY AUTHORITY: That the BCRUA Quarterly Investment Report, attached hereto as Exhibit "A" and incorporated herein, is hereby received and accepted. The Board of Directors hereby finds and declares that written notice of the date, hour, place and subject of the meeting at which this Resolution was adopted was posted and that such meeting was open to the public as required by law at all times during which this Resolution and the subject matter hereof were discussed, considered and formally acted upon, all as required by the Open Meetings Act, Chapter 551, Texas Government Code, as amended. RESOLVED this 28th day of July, 2021. NAC LE THOMPSON, Prekident Brushy Creek Regional Utility Authority ATTEST: AN E DUFFY, Secreta hops:lhuunJnxktciati.zhrm�rint.cnrtJsitc.JAdmmtxtravuNlklrrnmcm h 1eA1CkUAlli-,ard I'arkci%nluicl tAkumcniv2t121111728211211kc.c.BCRUA QLLarurly Inreslmem Wrx,rr Inr January 1.2021-March It 2021 HNH77134xA0 K1'Rl.dm BRU HY CEEK REGIONAL UTILITY AUTHORITY A Partnership of Cedar Park. Leander, and Round Rock Quarterly Investment Report January 1, 2021 — March 31, 2021 PATTERSON & ASSOCIATES 0 a 114 EXHIIBff * ' '111EST"rNT PDOFESeIrlm-' e What's Driving Rates? And Where? Payrolls in March surged with improvement in most industries—up 5,000 5,000 916,000 jobs and a lower rate(6%). The increase in payrolls is directly tied to vaccinations and a 0 0 relaxing of regulations. •5.000 -5,000 Businesses are reopening and gaining momentum with eased Employment Improves as restrictions. ISM Services index rose to its highest read since 1997. -10.000 economy opens up -10,000 That means producers are optimistic of an ongoing recovery. A stimulus fueled consumer is out to spend those checks. -15.000 -15,000 Business are encouraged to hire as long as the view improves. •20,000 1 -20,000 Housing continues to boom although slowing slightly as inventories decrease. -2s,000 Change in Total Nonfarm Employment(SA.Thous) -25,000 The economy is growing at its fastest pace since 19&3,which led + JAN MAR MAY 2020 L SEP NPI OV JAN MAR the IMF to predict it will surpass its pre-pandemic size. Thanks in Source: Bureau of Labor StatisticslHaverAnalytics large part to the$1.9 trillion virus stimulus package. The warning remains the same from the Fed who says we ares from complete but they continue to provide extraordinary markets.o 15.0 Fed Full Employment 4.7.5.8% support, unemployment Rate% The Fed is supporting the economy through continued buying of 12.5 12.5 securities. This drives stock investors into new historic nose bleed heights— 10.0 10.0 the S&P hits 4,000 for the first time. This does cause risks -more for stocks than bonds—as regulators 7.5 7.5 target hedge funds(Archegos)and private funds. s.0 s.o 2.5 2.5 2008 2010 2012 2014 2016 2018 2020 Source: Bureau of Labor Statistics/Haver Analytics Big, Bold and Expensive ice"; The new administration is ready to launch its new package to"Build Back Better." The estimated$2 trillion plan will start with jobs and The Fed remains on hold... tackle infrastructure,climate and emissions. A package this size— from homes to high speed rail-could lift productivity and GDP with 59%spent in the first year. But it could squeeze out private and state/local investments also. At least some in Congress have to be questioning whether this size of an additional stimulus is needed at this point right after passing i $2T,the impact of which has yet to be felt. 11 Additionally,some do question the sheer size with debt already at alarming levels. With the combined Trump/Biden$5.7T in stimulus 95p ATP ONES spending,the US debt to GDP ratio is already over 100%.With intra- governmental debt that rises it to 128%. Sometimes more is just more. The Fed is remaining on hold despite their optimistic outlook which includes a 6.5%growth rate in 2021,a 2.4%inflation rate,and a decline 5 5 in the unemployment rate to 4.5%. Chair Powell has indicated that . PCE YoY%12-month avg future adjustments will be made on realized improvements not # Care PCE YoY%12-month avg 4 -- Fed's 2.0%Target 4 anticipation of that improvement. Not all Fed Presidents agree. Dallas Fed President Kaplan has forecast a rate hike next year in order to wean off the Fed's extraordinary efforts in supporting the economy and the s s markets. Meanwhile,of course,geopolitics continue apace. China has been 2 2 flexing its muscles in military exercises surrounding Taiwan. Some of that bravado could come from their hesitancy to add to debt to fight 1 1 the pandemic. They really want to be the world's reserve currency. The major moves in the stock market have helped to entice investors 0 Inflation is behaving 0 out of bonds rising longer rates, but risk can be dangerous as we saw with the Robinhood debacle and the Achegos hedge fund implosion. -1 .1 1990 1995 2000 2005 2010 2015 2020 Makes you glad you are in the bond market even with low rates! Source: Bureau of Economic Analysis/Haver Analytics -.13k A Different Look ONALS The curve is reacting to an improving economy and feeding off the stimulus trough that promises even more funds thrown into the economy. The bond market is foreseeing inflation. The market will fight the Fed and their asset purchases on the long end. Usually the market wins.The rates are going up. The various Covid vaccines have been a major boost to confidence.A more robust economic recovery may require several more months. The Fed has stated its intention to stay at 0.0%Fed Funds through 2023. Looks like the curve will do its job for it. 3.00% The long end—often called the'bond vigilantes'are foreseeing inflation and taking the long end up. This is a '°°% `bear steepenin . 1.73% Mar-21 -21 Jan-21 x.5096 T- —Oct-2o 0.93% Jun-2o �.ao96 / 0.50% 0.1 / I 0.00% 0.02% 0.03% 0.06% / 0.00% Fed Funds 3mo 6mo iyr 2yr syr ioyr 30Yr End of Month Rates-Ful! Yield Curve—Fed Funds to 30yr Brushy Creek Regional Utility Authority (RUA), Texas Quarterly investment Report January—March 2021 Portfolio Summary Management Report This quarterly report is prepared in compliance with the Investment Policy and Strategy of the Authority and the Public Funds Investment Act (Chapter 2256.,Texas Government Code). Port olio as of December 31, 2020 Portfolio as of March 31, 2021 Beginning Book Value $ 27,474,294 Ending Book Value S 29,223,660 Beginning Market Value $ 27,474,294 Ending Market Value S 29,223,660 Investment Income for the period $ 5,739 Unrealized Gain/Loss $ 0 Unrealized Gain/Loss $ 0 Change in Unrealized Gain/Loss $ 0 WAM at Beginning Period Date' I day WAM at Ending Period Date' 1 day Change in Market Value' S 1,749,366 Average Yield to Maturity for period 0.078% Average Yield 6 month Treasury Bill for period 0.070% Average Yield 1 Year Treasury Note for period 0.080% Authorized by: GL.trt Karen Bondy, General ager Liirda P tterson, President Brushy Creek RUA Patterson &Associates I WAM,represents weighted average maturity. 2 Change in Markel Value" is required data,but will primarily reflect the receipt and expenditure of the Authority's funds from quarter to quarter. IN- - - Your Portfolio 1241- As of March 31 , 2021 P&A constantly reviews your portfolio for optimal asset allocation and a controlled average maturity because a diversified portfolio can better adjust to volatile market conditions. These are unusual times and where extensions can be made it is important to make them to find any available safe value in the markets. The graphs below show asset allocations by market sector and by maturity in your portfolio. Liquidity has been reduced to little or no value but with a flat short curve it may be the only sector available out to twelve months without the use of CP. Our expectation is of continuing dismally low rates but we look for value in your authorized sectors to capture the yield available as markets change. Your net yield of 0.08%compared to some basic benchmarks generated additional quarterly earnings of: a Q 3 mo.T-Bill $2,186.73 Q 6 mo.T-Bill $657.54 Q 1 yr T-Bill $(107.05) Wells Fargo BNY Cash O00 4.247% 0.000% p0 MM O 8.021% 00 00 `L �O O TexStar ���o`' 87.732% O '� rcl Ci ri►rrclur� r rnarstl+Tt:r Patterson&Associates Brushy Creek Reg. Utility Auth 901 S-MoPac Suite 195 Portfolio Management Austin,TX 78746 Portfolio Summary iNYWMENT rllOrrs1110MAL6 March 31, 2021 Par Market Book %of Days to YTM Investments Value Value Value Portfolio Term Maturity 366 Equiv. TexSTAR 25,638,413.90 25,638,413 90 25,638,413.90 87,73 1 1 0-022 Money Market 2,344,285.44 2,344,285.44 2,344,285.44 8.02 1 1 0.450 Wells Fargo 1,240,961.14 1,240,961.14 1,240,961.14 4,25 1 1 0-160 29,223,660.48 29,223,660.48 29,223,660.48 100.00% 1 1 0.062 Investments Total Earnings March 31 Month Ending Fiscal Year To Date Current Year 1,457.72 15,809.02 The following reports are submitted in accordance with the Public Funds Investment Act(Texas Gov't Code 2256). The reports a so offer supplemental Information not required by the Act in order to fully inform the governing body of Brushy Creek Regional Utility Authority of the position and activity within the Authority's portfolio of investment. The reports include a management summary overview,a detailed Inventory report for the end of the period,a transaction report,as well as graphic representations of the portfolio to provide full disclosure to the governing body. 4 �L 7123121 Karen Bondy,General Man Reporting period 0310112021-0313112021 Portfolio BCRU Data Updated SET_BCRU:04/22/2021 17:35 AP Run Date 04!2212021-1735 PMPRFPM1)7.3.0 Repo_rt Ver 7 3 6-1 FATTEIIIN 0 AINICIATE! Patterson&Associates Brushy Creek Reg. Utility Auth 901 S.MoPac 195 Summary by Type Austin,TX 1te 78746 March 31, 2021 INfliTYENT FNOPE63101lAL6 Grouped by Fund Number of Per 96 of Average Average Days Security Type investments y a Book Value Po olio I Fund: Construction Funds Money Market 2 2,344,285.44 2,344,285.44 8.02 0.450 1 TexSTAR 4 1,010,441.45 1,010,441.45 3.46 0.022 1 Wells Fargo 3 12.82 12.82 0.00 0.136 1 Subtotal 9 3,354,739.71 3,354,739.71 11.48 0.321 1 Fund: Construction Funds-2017 SWIFT TexSTAR 3 609,195.05 609,195.05 2.08 0.022 1 Subtotal 3 809,195.05 609,195.05 2.08 0.022 1 Fund: Construction Funds-2018 SWIFT TexSTAR 2 1,369,407.78 1,369,407.78 4.69 0.022 1 Subtotal 2 1,369,407.78 1,369,407.76 4.69 0.022 1 Fund: Debt Service Funds TexSTAR 4 3,294,548.34 1294.548.34 11.27 0.022 1 Subtotal 4 3,294,548.34 3,294,548.34 11.27 0.022 1 Fund: Escrow Funds BNY CASH 3 0.00 0.00 0.00 0.000 0 Money Market 3 0.D0 0.00 0.00 0.000 0 TexSTAR 3 10,658,749.59 10,658,749.59 36.47 0.022 1 Subtotal 9 10,658,748.59 10,658,749.59 36.47 0.022 1 Fund: Escrow Funds-2017 BNY CASH 3 0.00 0.00 0.00 0.000 0 TexSTAR 3 1,899,921.68 1,899.921.68 6.50 0.022 1 Subtotal 6 1,899,921.88 1,899,921.68 6.50 0.022 1 Fund: Escrow Funds-2018 BNY CASH 2 0.00 0.00 0.00 0.000 0 TexSTAR 2 4,630,481.86 4,630,481.86 15.84 0.022 1 Portfolio BCRU AP Run Dale:04122/2021 17 33 ST(PRF_ST)7.2.0 Report Ver.7.3.6.1 Brushy Creek Reg.Utility Auth Summary by Type Page 2 March 31,2021 Grouped by Fund Number of Per %of Average Average Days Security Type Investments, Value Book Value portfolio 365 lo Maturity Subtotal 4 4,630,481.86 4,630,481.66 15.84 0.022 1 Fund: Operating Funds TexSTAR 1 2,165,668.15 2,165,668.15 7.41 0.022 1 Wells Fargo 1 1,240,948.32 1,240,948.32 4.25 0.160 1 Subtotal 2 3,406,616.47 3,405,616.47 11.66 0.072 1 Fund: Reserve Funds TexSTAR 1 0.00 0.00 0.00 0.000 0 Subtotal 1 0.00 0.00 0.00 0.000 0 Total and Average 40 29,223,660.48 29,223,660.48 100.00 0.062 1 Portfolio BCRU AP Rurt Date:04!22!2021.17 33 ST(PRF-ST)7 2.0 Repot Ver 7 3.6.1 rarrcriotll ` �aaoe�aTEro r &Associates 1 Brushy Creek Reg. Utility Auth Patterso 901 S.MoPaC AFund CON-Construction Funds Suite 195 Austin,TX 78746 Investments by Fund March 31, 2021 Purchase Current YTM YTM Maturity Days To CUSIP Investment 0 issuer Date Book Value Par Value Market Value Rate 360 366 Date Maturity TexSTAR 2461110300 10252 TexStar Master 01/01/2018 20,120.09 20,120.09 20.120.09 0.022 0.021 0.021 1 246131030000 10006 TexSTAR-Cedar Park 10/15/2009 150,370.40 150,370.40 150,370.40 0.022 0.021 0.021 1 246141030000 10007 TexSTAR-Leander 10/15/2009 631,737.96 631,737.96 631,737.96 0.022 0.021 0.021 1 246161030000 10008 TexSTAR-Round Rock 10115/2009 208.213.00 208,213.00 208,213.00 0.022 0.021 0.021 1 Subtotal and Average 1,010,441.45 1,010,441.45 1,010,441.45 0.021 0.022 1 Money Market 6095A 10315 NexBBnk ICS-Round Rock 0910512019 2,344.285.44 2.344,285 44 2.344.285.44 0 450 0.443 0460 1 6095 10314 NexBank Public MM-Round Rock 0910412019 0.00 0.00 0.00 1 Subtotal and Average 2,344,285.44 2,344,285.44 2,344,285.44 0.444 0.450 1 Wells Fargo 8940 10204 Wells Fargo Bus Chkg-C Park 08/0212016 4.37 4.37 4.37 0.160 0.157 0 160 1 8932 10205 Wells Fargo Bus Chkg-Leander 0810112016 6.51 6.51 6.51 0.160 0.157 0160 1 8916 10206 Wells Fargo Bus Chkg-R Rock 0810112016 1.94 1.94 1.94 1 Subtotal and Average 12.82 12.82 12.82 0.134 0.136 1 Total Investments and Average 3,354,739.71 3,354,739.71 3,354,739 71 0.317 0.321 1 Run Date 04/2212021•17:33 FI(PRF FI)7.1 1 Report Ver 7 3.6 1 Fund CON17-Construction Funds-2017 SWIFT Investments by Fund Page March 31, 2021 Purchase Current YTM yTM Maturity Days To CUSIP Investment# Issuer Date Book Value Per Value Markat Value Rete 360 366 Date Maturity TexSTAR 2461320170 10286 TexSTAR-Cedar Park 02104/2019 163,237.88 163,237.88 163,237.88 0.022 0.021 0.021 1 2461420170 10287 TexSTAR-Leander 02/04/2019 283,421.59 283,421.59 283,421.59 0.022 0.021 0.021 1 2461620170 10288 TexSTAR•Round Rock 02104/2019 162,535.58 162,535.58 162,535.58 0.022 0.021 0.021 1 Subtotal and Average 609,195.05 609,195.05 809,195.05 0.021 0.022 1 Total Investments and Average 609,195.05 809,195.05 609,195.05 0.021 0.022 1 Portfolio BCRU AP Run Date:04122!2421-17:33 FI{PRF-F)7 1.1 Report Ver.7.3.6.1 Fund CON18-Construction Funds-2018 SWIFT Investments by Fund Page 3 March 31, 2021 Purchase Current YTM yTM Maturity Days To CUSIP Investment 0 Issuer Date Book value Par Value Market Value Rate 360 365 Date Maturity TexSTAR 2461320180 10289 TexSTAR•Cedar Park 03/07/2019 484,190.34 484,190.34 484,190.34 0.022 0 021 0.021 1 2461420180 10290 TexSTAR.Leander 03/04/2019 885,217.44 885,217.44 885,217.44 0.022 0.1121 0.021 1 Subtotal and Average 1,369,407.78 1,369,407.78 1,369,407.78 0.021 0.022 1 Total Investments and Average 1,369,407.78 1,369,407.78 1,369,407.78 0.021 0.022 1 Portfolio ECRU AP FI(PRF F0 7.1 1 Report Ver,7,3.6.1 Fund DS- Debt Service Funds Investments by Fund Page March 31, 2021 Purchase Current yTM YTM Maturity Days To CUS1P Investment# Issuer Date Book Value Par Value Market Value Rate 5 Date Murity TexSTAR 2461110230 10253 TexStar Master 01/01/2018 3,089.47 3,089.47 3,089.47 0.022 0.021 0.021 1 246131023000 10003 TexSTAR-Cedar Park 10/01/2009 663.614.20 663,614.20 663,614.20 0.022 0.021 0.021 1 246141023000 10004 TexSTAR-Leander 10/01/2009 1,537.578.15 1,537,578.15 1,537,578.15 0.022 0.021 0.021 1 246161023000 10005 TexSTAR-Round Rock 10/01/2009 1,090,266.52 1.090,266.52 1,090,266.52 0.022 0.021 0.021 1 Subtotal and Average 3,294,548.34 3,294,548.34 3,294,548.34 0.021 0.022 1 Total Investments and Average 3,294,548.34 3,294,548.34 3,294,548.34 0.021 0.022 1 Portfolio BCRU AP Run Date 0412212421 17:33 FI(PRF_FI)7.1 1 Report Ver 7 16.1 Fund ESC-- Escrow Funds Investments by Fund Page 5 March 31, 2021 Purchase Current YTM YTM Maturity Days To CUSIP Investment 8 Issuer Date Book Value Par Value Market Value Rata 360 385 Date Maturity BNY CASH 99998 10283 BNY Cash•Cedar Park 1010112020 0.00 000 0.00 1 99994 10267 BNY Cash-Leander 1010112020 0.00 0.00 0.00 1 99995 10268 BNY Cash-Round Rock 1010112020 0.00 0.00 0.00 1 Subtotal and Average 0.00 0.00 0.00 0.000 0.000 0 TexSTAR 246122009000 10000 TexSTAR-Cedar Park 10101/2009 938,368.05 938,368.05 938,368.05 0.022 0.021 0.021 1 246122009001 10001 TexSTAR-Leander 10/01/2009 3,623.317.16 3,623,317.16 3,623,317.16 0.022 0.021 0 021 1 246122009002 10002 TexSTAR-Round Rock 10101/2009 6.097.064.38 6,097,064.38 6.097,064.38 0.022 0.021 0.021 1 Subtotal and Average 10,658,749.59 10,658,748.59 10,658,749.59 0.021 0.022 1 Money Market 86.64004317 10188 East West MM-Cedar Park 04/16/2014 0.00 0.00 0.00 1 86.64004325 10189 East West MM-Leander 04/16/2014 0.00 0.00 0.00 1 86.64004226 10190 East West MM-Round Rock 04/16/2014 0.00 0.00 0.00 1 Subtotal and Average 0.00 0.00 0.00 0.000 0.000 0 Total Investments and Average 10,858,749.59 10,858,749.59 10,658,749.69 0.021 0.022 1 Portfolio BCRU AP Run Daw 0412V2021•17.33 FI(PRF_FI)7 1.1 Report Ver 7 3.6.1 Fund ESC17- Escrow Funds -2017 Investments by Fund Page March 31, 2021 Purchase Current YTM YTM Maturity Days To CUSIP Investment 0 Issuer Date Book Value Par Value Market Value Rate 360 365 Date Maturity BNY CASH 99991 10223 BNY Cash-Cedar Park 10/01/2020 0.00 0.00 0.00 1 99992 10224 SNY Cash-Leander 10/01/2020 0.00 0.00 0.00 1 99993 10225 BNY Cash-Round Rock 1010112020 0.00 0.00 OAO 1 Subtotal and Average 0.00 0.00 0.00 0.000 0.000 0 TexSTAR 2461220170 10280 TexSTAR-Cedar Park 0113012019 389,311.35 389.311.35 389,311.35 0.022 0.021 0.021 1 2461220171 10281 TexSTAR-Leander 0113012019 1,121,452.20 1,121,452.20 1,121.452.20 0.022 0.021 0 021 1 2461220172 10282 TexSTAR-Round Rock 0113012019 389,158.13 389,158.13 389.158.13 0.022 0.021 0 021 1 Subtotal and Average 1,899,921.88 1,899,921.68 1,899,921.68 0.021 0.022 1 Total Investments and Average 1,899,921.88 1,899,921.68 1,899,921.68 0.021 0.022 1 Portfolio ECRU AP Run Date:0412212021-17 33 F1(PRF_Fl)7 1.1 Report Ver.7.3.6.1 Fund ESC18- Escrow Funds -2018 Investments by Fund Page March 31, 2021 Purchase Current YfM YTM Maturity Days To CUSIP Investment# Issuer Date Book Value Par Value Market Value Rate 360 365 Date Maturity BNY CASH 99997 10270 BNY Cash-Cedar Park 1010112020 0.00 0.00 0.00 1 99996 10269 BNY Cash-Leander 1010112020 0.00 0.00 0.00 1 Subtotal and Average 0.00 0.00 0.00 0.000 0.000 0 TexSTAR 2461220180 10284 TexSTAR-Cedar Park 02/15/2019 2,487,936.43 2,487,936.43 2,487,936.43 0.022 0.021 0.021 1 2461220181 10285 TexSTAR-Leander 0212812019 2,142,545.43 2.142,545.43 2,142.545.43 0.022 0.021 0.021 1 Subtotal and Average 4,630,481.86 4,630,481.86 4,630,481.86 0.021 0.022 1 Total Investments and Average 4,630,481.86 4,630,481.86 4,630,481.86 0.021 0.022 1 Portfolio ECRU AP Run Date!04122J2021-17 33 FI(PRF FI)7 1.1 Report Ver.7.3.6.1 Fund OPER-Operating Funds Investments by Fund Page 8 March 31, 2021 Purchase Current yTM YTM Maturity Days To CUSIP Investment i Issuer Date Book Value Par Value Market Value Bate 360 365 Date Maturity TexSTAR 2461111110 10254 TexStar Master 01/01/2018 2,165.668.15 2.165.668.15 2,165,668,15 0.022 0.021 0.021 1 Subtotal and Average 2,165,668.15 2,165,668.16 2,165,688.15 0.021 0.022 1 Wells Fargo 5125 10199 Wells Fargo Bus Chkg-Oper 05/26/2016 1,240,948.32 1,240,948.32 1,240,948.32 0.160 0.157 0.160 1 Subtotal and Average 1,240,946.32 1,240,948.32 1,240,948.32 0.158 0.160 1 Total Investments and Average 3,408,616.47 3,406,616.47 3,406,616.47 0.071 0.072 1 Portfolio BCRU AP Run Date:04122!2021 17:33 FI(PRF Fl)7 1.1 Repan Ver.7.3.6.1 Fund RES- Reserve Funds Investments by Fund Page March 31, 2021 Purchase Current yTM YTM Maturity Days To CUSIP Investment t Issuer Date Book Value Par Value Market Value Rate 360 365 Data Maturity TexSTAR 246146233000 10043 TexSTAR.Leander 03/25/2010 0.00 0.00 0.00 1 Subtotal and Average 0.00 0.00 0.00 0.000 0.000 0 Total Investments and Average 0.00 0.00 0.00 0.000 0.000 0 Portfolio BCRU AP Run Date:0412212021•17 33 FI(PRF FI)7 1.1 Report Ver.7.3.6.1 PAFTER600 O ABiOCIATES Patterson&Associates Brushy Creek Reg. Utility Auth 901 S.MoPac Interest Earnings Suite 145 9 Austro,TX 78746 Sorted by Fund -Fund INY!I•TWIM7 PROPEi6IOMAL6 January 1, 2021 - March 31, 2021 Yield on Average Book Value Adjusted Interest Earnings Security Fading Beginning Average Maturity Current Annualized Interest Amortization/ Adjusted Interest CUSIP Investment# Fund Type Par Value Book Value Book Value Date Rate Yield Earned Accretion Earnings Fund:Construction Funds 246131030000 10006 CON RRP 150,370.40 290.159.28 227.847.35 0.022 0.042 23.45 0.00 23.45 246161030000 10008 CON RRP 208,213.00 359,858.31 283,411.99 0.022 0.039 27.48 0.00 27.48 246141D30000 10007 CON RRP 631,737.96 874,818.99 766.547.25 U.022 0.040 75.40 0.00 75.40 8932 10205 CON RR5 6.51 6.50 6.50 0.160 1.248 0.02 0.00 0.02 8940 10204 CON RR5 4.37 4.36 4.36 0.160 1.860 0.02 0.00 0.02 8916 10206 CON RR5 1.94 194 1,94 0.00 0.00 0.00 2461110300 10252 CON RRP 20.120.09 20,118.21 20,119,09 0.022 0.038 1.88 0.00 1.B8 6095A 10315 CON RR4 2,344,285.44 2,841,313,52 2,675,777.27 0.450 0.450 2,969.21 000 2,969.21 Subtotal 3,354,739.71 4,388,281.11 3,973,715.76 0.316 3,097.46 0.00 3,097.46 Fund:Construction Funds-2017 SWIFT 2461320170 10286 CON17 RRP 163.237.88 181,590.04 90.99071 0.022 0.045 10.12 0.00 10.12 2461620170 10288 CON17 RRP 162.535.58 189,887.24 94.48822 0.022 0.046 10.61 0.00 10.61 2461420170 10287 CON17 RRP 283.421.59 316,744.16 157.58984 0.022 0.045 17.61 0.00 17.61 Subtotal 809,195.05 888,221.44 343,088.78 0,045 38.34 0.00 38.34 Fund:Construction Funds-2018 SWIFT 2461320180 10289 CON18 RRP 484,190.34 1,019.218.73 $23,974.39 0.022 0.041 8293 0.00 82.93 2461420180 10290 CON18 RRP 885,217.44 1.676,844.17 1 387.628.80 0.022 0.040 13851 O.DO 13851 Subtotal 1,369,407.78 2,696,062.90 2,211,603.16 0.041 221.44 0.00 221.44 Fund:Debt Service Funds 246131023000 10003 DS RRP 663.614 20 16.059.48 628,471.39 0 022 0.035 54.73 0.00 54 73 246161023006 10005 DS RRP 1,090.266 52 42.671.42 1.069,977.32 0 022 0.036 95.10 0.00 9510 246141023000 10004 DS RRP 1,537.578.15 60.137.90 1.552,932.07 0.022 0037 140.25 0.00 140.25 2461110230 10253 DS RRP 3,08947 3,08927 3.089.38 0.022 0.026 0.20 0.00 0.20 Subtotal 3,294,648.34 121,968.07 3,254,470.18 OA34 290.28 0.00 2W.28 Fund:Escrow Funds 246122009000 10000 E5C RRP 938.368.05 938,280.33 938,321.61 0.022 0.038 87.72 000 87.72 246122009002 10002 ESC RRP 6.097,064.38 6.096.494.80 6,096.762.86 0.022 0.038 569.58 DUO 569.58 Portfolio BCRU AP Run Date:0412812021-16 30 IE(PRF.IE)7.2.0 Report Ver 7 3.6 1 Brushy Creek Reg.Utility Auth Interest Earnings Page 2 January 1,2021-March 31,2021 Adjusted Interest Earnings Security Ending Beginning Average Maturity Current Annualized Interest Amortization/ Adjusted Interest CUSIP Investment# Fund Type Par Value Book Value Book Value Date Rate Yield Earned Accretion Earnings Fund:Escrow Funds 246122009001 10001 ESC RRP 3.623.317.16 3,622,978.65 3,623.137.95 0.022 0.038 338S11 000 338.51 Subtotal 10,658,749.59 10,657,753.78 10,658,222.41 0.038 895.81 0.00 995.81 Fund:Escrow Funds-2017 2461220170 10280 ESC17 RRP 389,311.35 639.335.97 611,577.07 0.022 0.039 58.55 0.00 58.55 2461220172 10282 ESC17 RRP 389,158.13 639,182.75 636,432.18 0.022 0.037 58.55 0.00 58.55 2461220171 10281 ESC17 RRP 1,121,452.20 1,558,836.77 1.510,291.17 0.022 0.039 143.65 0.00 143.65 99991 10223 ESC17 LAI 0.00 0.09 0.04 0.00 0.00 0.00 99992 10224 ESC17 LAI 0.00 0.26 0.12 0.00 0.00 0.00 99993 10225 ESC17 LAI 0.00 0.09 0.04 0.00 0.00 0.00 Subtotal 1,899,921.68 2,837,355.93 2,758,300.62 0.038 280.75 0.00 260.75 Fund:Escrow Funds-2018 2461220180 10284 ESC18 RRP 2,487,936.43 2,487,695.77 2,487,809.56 0.022 0.038 232.38 0.00 232.38 2461220181 10285 ESCIS RRP 2.142,545.43 2,142,333.74 2,142,434.09 0.022 0.038 200.14 0.00 200.14 99997 10270 ESC18 LAI 0.00 8.07 2,895.87 0,0C 0.00 0.00 99996 10269 ESC18 LAI 0.00 11.55 5.39 U.00 0.00 0.00 Subtotal 4,630,481.66 4,630,049.13 4,633,144.91 0.038 432.52 0.00 432.52 Fund:Operating Funds 5125 10199 OPER RR5 1.240,948.32 467,890.50 526.895.05 0.160 0.167 216.73 7.00 216.73 2461111110 10254 OPER RRP 2,165,668.15 988,720.67 2,098,896,11 0022 0.036 185.99 ;100 185.99 Subtotal 3,406,616.47 1,456,611.17 2,625,791,17 0.062 402.72 0.00 402.72 Total 29,223,680.48 27,474,293.53 30,458,316.98 0.076 5,739.32 0.00 5,739.32 Portfolio BCRU AP Run Dale:0412812021.16:30 IE(PRF_IE2 7 2.0 Report Ver.7.3.6.1 PATTERAIN I A11E06 AIE3 Patterson&Associates Brushy Creek Reg. Utility Auth 901 S.MoPac Suite 195 Texas Compliance Change in Val Report Austin,TX 78746 6L. 9 Sorted by Fund -Wr PROPEASI01111L6 January 1, 2021 - March 31, 2021 Beginning Ending Inv# Issuer Fund Purch Date Interest Accrual Book Value Book Value Beginning Purchases! Ending Cusp Par Value YTM Mat Date Interest Received Market Value Additions Redemptions Change in Value Market Value Fund:Construction Funds 10006 TXSCP CON 10115!2009 23.45 290,159.28 23.45 139.812.33 -139,788.88 150,370.40 246131030000 150,370.40 0.021 I1 23.45 290,159.28 23.45 139.812.33 -139,788.88 150,370.40 10007 TXSLE CON 10/15/2009 75.40 874,818.99 75.40 243,156.43 -243,081.03 631,737.96 246141030000 631,737.96 0.021 11 75,40 874,818.99 75.40 243,156.43 -243,081.03 631,737.96 10008 TXSRR CON 10/15/2009 27.48 359.858.31 500,991.48 652.636.79 -151,645.31 208,213.00 246161030000 208,213.00 0.021 11 27.48 359,858.31 500,991.48 652.636.79 -151,645.31 208,213.00 10204 WFBCCP CON 08/02/2016 0.02 4.36 0.02 0.01 0.01 4.37 8940 4.37 0.160 11 0.02 4.36 0.02 0.01 0.01 4.37 10205 WFBCLE CON 08/01/2016 0.02 6.50 0.02 0.01 0.01 6.51 8932 6.51 0.160 11 0.02 6.50 0.02 0.01 0.01 6.51 10206 WFBCRR CON 08/01/2016 0.00 1.94 0.00 0 00 0.00 1.94 8916 1.94 0.000 11 0.00 1.94 0.00 0.00 0.00 1.94 10252 TXMAST CON 0110112018 1.88 20,118.21 819,234.57 819,232.69 1,8B 20.120.09 2461110300 20,120.09 0.021 11 1.88 20,118.21 819,234.57 819,232.69 1.88 20,120.09 10314 NXMMRR CON 0910412019 0.00 0.00 0.00 0.00 0.00 0.D0 6095 0.00 0.000 11 0.00 0,00 0.00 0.00 0.00 0.00 10315 NICSRR CON 09/0512019 2,969.21 2,841,313.52 2,971.92 500,000.00 -497,028.08 2,344,285.44 6095A 2,344,285.44 0.450 11 2,969.21 2,841,313.52 2,971.92 500.000.00 -497,028.08 2,344,285.44 Sub Totals For:Fund:Construction Funds 1097.46 4,386,281.11 1,323,296.86 2.354,838.26 -1.031,541,40 3,354,739.71 3,097.46 4,386,281.11 1,323,296.86 2,354,838.26 -1,031.541.40 3,354,739.71 Fund:Construction Funds- 10286 TXSCP CON17 02/04/2019 10.12 181,590.04 250,093.38 268,445.54 -18,352.16 163,237.88 2461320170 163,237.88 0.021 11 10.12 181.590.04 250,093.38 268.445.54 -18,352.16 163,237.88 Portfolio ECRU Run Date:0412812021-16:33 TC(PRF TC17.0 Report Ver.7.3.6.1 Brushy Creek Reg.Utility Auth Texas Compliance Change in Val Report Page 2 January 1,2021-March 31,2021 Beginning Ending Inv# Issuer Fund Purch Date Interest Accrual Book Value Book Value Beginning Purchases/ Ending Cusip Par Value YTM Mat Date Interest Received Market Value Additions Redemptions Change in Value Market Value 10287 TXSLE CON17 02/0412019 17.61 316,744.16 437,546.09 470,868.66 .33,322.57 283,421.59 2461420170 283,421.59 0.021 11 17.61 316,744.16 437,546.09 470,868.66 .33,322.57 283,421.59 10288 TXSRR CON17 0210412019 10.61 189,887.24 250,093.87 277,445.53 -27,351.66 162,535.58 2461620170 162,535.58 0.021 11 10.61 189.887.24 250.093.87 277,445.53 -27.351.66 162,535.58 Sub Totals For:Fund:Construction Funds- 38.34 688,221.44 937,733.34 1,016,759.73 -79,026.39 609,195.05 38.34 688,221.44 937,733.34 1,016,759.73 -79,026.39 609.195.05 Fund:Construction Funds- 10289 TXSCP CON18 03/07/2019 82.93 1,019,218.73 82.93 535-111.32 -535,028.39 484.190.34 2461320180 484,190.34 0.021 11 82.93 1,019,218.73 82.93 535111.32 -535,028.39 484.190.34 10290 TXSLE CON18 03/04/2019 138.51 1,676,844.17 573.51 792,200.24 -791,626.73 885,217.44 2461420180 885,217.44 0.021 I1 138.51 1,676,844,17 573.51 792,200.24 -791.626.73 885,217.44 Sub Totals For:Fund:Construction Funds- 221.44 2,696,062.90 65644 1,327,311.56 -1,326,655.12 1,369,407.78 221.44 2,696,062.90 65644 1,327,311.56 1.326,655 12 1,369,407.78 Fund:Debt Service Funds 10003 TXSCP DS 10/01/2009 54.73 16,059.48 1,139,629.47 492,074.75 647.554.72 663,614.20 246131023000 663,614.20 0.021 11 54.73 16,059.48 1.139,629.47 492,074,75 647.554.72 663.614.20 10004 TXSLE DS 10101/2009 140.25 60.137.90 3,061,555.75 1,584,115.50 1.477,440.25 1,537,578.15 246141023000 1.537.578.15 0.021 11 140.25 60.137.90 3.061,555.75 1,584,11550 1,477,440.25 1,537,578.15 10005 TXSRR DS 10/01/2009 95.10 42,671,42 2,117,898.10 1,070,303.00 1,047,595.10 1,090,266.52 246161023000 1,090,266.52 0.021 1 1 95.10 42.671.42 2,117,898.10 1,070,303.00 1.047,595.10 1,090,266 52 10253 TXMAST DS 01/0112018 0.20 3,089.27 0.20 0.00 0.20 3,08947 2461110230 3.089.47 0.021 11 0.20 3,089.27 0.20 0.00 0.20 3,089.47 Sub Totals For:Fund:Debt Service Funds 290.28 121,958.07 6,319,083.52 3,146,493.25 3.172.590.27 3.294,548.34 290.28 121,958.07 6,319,083.52 3,146,493.25 3,172.590.27 3,294,548.34 Fund:Escrow Funds 10000 TXSCP ESC 10/01/2009 87.72 938,280.33 87.72 0.00 87.72 938,368.05 246122009000 938,368.05 0.021 11 87.72 938,280.33 87.72 0.00 87.72 938,368.05 Portfolio BCRU Run Dale:04/2812021-16:33 TC(PRF_TC)7.0 Report Ver 7 3.6.1 Brushy Creek Reg.Utility Auth Texas Compliance Change in Val Report Page 3 January 1,2021-March 31,2021 Beginning Ending Inv# Issuer Fund Purch Date Interest Accrual Book Value Book Value Beginning Purchases! Ending Cusip Par Value YTM Mat Date Interest Received Market Value Additions Redemptions Change in Value Market Value 10001 TXSLE ESC 10/0112009 338.51 3,622.978.65 338.51 0.00 338.51 3,623,317.16 246122009001 3,623.317.16 0.021 11 338.51 3,622.978.65 338.51 0.00 338.51 3,623,317.16 10002 TXSRR ESC 10/01/2009 569.58 6,096,494.80 569.58 0.00 569.58 6,097,064.38 246122009002 6,097,064.38 0.021 11 569.58 6,096,494.80 569.58 0.00 569.58 6,097,064.38 10188 EWMMCP ESC 04/16/2014 0.00 0.00 0.00 0.00 0.00 0.00 86-64004317 0.00 0.000 11 0.00 0.00 0.DO 0.00 0.00 0.00 10189 EWMMLE ESC 04/16/2014 0.00 0.00 0.00 0.00 0.00 0.00 86-64004325 0.00 0.000 11 0.00 0.00 0.00 0.00 0.00 0.00 10190 EWMMRR ESC 04/16/2014 0.00 0.00 0.00 0.00 0.00 0.00 86-64004226 0.00 0.000 11 0.00 0.00 0.00 0.00 0.00 0.00 10267 CASHLE ESC 10/01/2020 0.00 0.00 0.00 0.00 0.00 0.00 99994 0.00 0.000 11 0.00 0.00 0.00 0.00 0.00 0.00 10268 CASHRR ESC 10/01/2020 0.00 0.00 0.00 0.00 0.00 0.00 99995 0.00 0.000 11 0.00 0.00 0.00 0.00 0.00 0.00 10283 CASHCP ESC 1010112020 UO 0.00 0.00 0.00 0.00 0.00 99998 0.00 0.000 11 0.00 0.00 0.00 0.00 0.00 0.DO Sub Totals For:Fund:Escrow Funds 995.81 10,657.753.78 995.81 0.00 995.81 10,658,749.59 995.81 10.657,753.78 995.81 0.00 995.81 10,658,749.59 Fund:Escrow Funds-2017 10223 CASHCP ESC17 10/01/2020 0.00 0.09 0.00 0.09 -0.09 0.00 99991 0.00 0.000 11 0.00 0.09 0.00 0.09 -0.09 0.00 10224 CASHLE ESC17 10/0112020 0.00 0.26 0.00 0.26 -0.26 OAO 99992 0.00 0.000 11 0.00 0.26 0.00 0.26 -0.26 0.00 10225 CASHRR ESC17 10/01/2020 0.00 0.09 0.00 0.09 -0.09 0.00 99993 0.00 0.000 11 0.00 0.09 0.00 0.09 -0.09 0.00 10280 TXSCP ESC17 0113012019 58.55 639,335.97 58.64 250,083.26 •250,024.62 3139,311.35 2461220170 389,311.35 0.021 1 1 58.55 639,335.97 58.64 250,083.26 -250,024.62 389,311.35 Portfolio ECRU Run Date 04128/2021•16:33 TC(PRF TQ 7 0 Report Ver 7 3.6.1 Brushy Creek Reg.Utility Auth Texas Compliance Change in Val Report Page 4 January 1,2021-March 31,2021 Beginning Ending Inv# Issuer Fund Purch Date Interest Accrual Book Value Book Value Beginning Purchases/ Ending Cusip Par Value YTM Mat Date Interest Received Market Value Additions Redemptions Change in Value Market Value 10281 TXSLE ESC17 01/30/2019 143.65 1,558,836.77 143.91 437,528.48 -437,384.57 1,121.452.20 2461220171 1,121.452.20 0.021 11 14165 1,558,836.77 143.91 437,528.48 -437,384.57 1,121,452.20 10282 TXSRR ESC17 0113012019 58.55 639,182.75 58.64 250,083.26 -250,024.62 389,158.13 2461220172 389.158.13 0.021 1 1 58.55 639,182.75 58.64 250,083.26 -250,024.62 389,158.13 Sub Totals For:Fund:Escrow Funds-2017 260.75 2,837,355.93 261.19 937,695.44 -937,434.25 1,899,921.68 260.75 2,837.355.93 261.19 937,695.44 -937,434.25 1.899.921,68 Fund: Escrow Funds-2018 10269 CASHLE ESC18 10/0112020 0.00 11.55 0.00 11.55 -11.55 0.00 99M 0.00 0.000 11 0.00 11.55 0.00 11-55 -11.55 0.00 10270 CASHCP ESC18 10/01/2020 0.00 8.07 65,071.96 65,080.03 -8.07 0.00 99997 0.00 0.000 11 0.00 8.07 65,071.96 65,080.03 -8.07 0.00 10284 TXSCP ESC18 02/15/2019 232.38 2.487,695.77 240.66 0.00 240.66 2,487,936.43 2461220180 2,487,936.43 0.021 11 232.38 2,487,695.77 240.66 0.00 240.66 2,487,936.43 10285 TXSLE ESC18 02/28/2019 200.14 2,142,333.74 211.69 0.00 211.69 2,142,545.43 2461220181 2.142.545.43 0.021 11 200.14 2,142.333.74 211.69 0.00 211.69 2,142,545.43 Sub Totals For:Fund:Escrow Funds-2018 432.52 4,630,049.13 65.524.31 65.091.58 432.73 4,630,481.86 432.52 4,630,649.13 65,524.31 65.091.58 432.73 4,630,481.86 Fund:Operating Funds 10199 wFBCOP OPER 05/26/2016 216.73 467,890.50 6,944,763.75 6.171.705.93 773,057.82 1,240,948.32 5125 1,240,948.32 0.160 11 216.73 467,890.50 6,944,763.75 6,171,705.93 773,057.82 1,240,948.32 10254 TXMAST OPER 01101/2018 185.99 988,720.67 1,662,142.89 485,195.41 1.176,947.48 2.165,668.15 2461111110 2,165.668.15 0.021 11 185.99 988,720.67 1,662,142.89 485,195.41 1,176,947.48 2,165.668.15 Sub Totals For:Fund:Operating Funds 402.72 1,456,611.17 8,606,906.64 6,656,901.34 1,950,005.30 3,406,616.47 402.72 1,456.611.17 8,606,906.64 6,656,901.34 1,950,005.30 3,406,616.47 Fund:Reserve Funds 10043 TXSLE RES 03/25/2010 0.00 0.00 0.00 0.00 0.00 0.00 246146233000 0.00 0.000 1 1 0.00 0.00 0.00 0.00 0.00 0.00 Portfolio BCRU Run Dale:04126/2021.16:33 TC(PRF,TC)7,0 Repot Ver-7.3.6.1 Brushy Creek Reg.Utility Auth Texas Compliance Change in Val Report Page 5 January 1,2021-March 31,2021 Beginning Ending Inv# Issuer Fund Purch Date Interest Accrual Book Value Book Value Beginning Purchases/ Ending Cusip Par Value YTM Mat Date Interest Received Market Value Additions Redemptions Change in Value Market Value Sub Totals For:Fund:Reserve Funds 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0,00 0.00 0.00 0.00 Report Grand Totals: 5,739.32 27,474,293.53 17.254.458.11 15,505,091.16 1,749,366.95 29,223,660.48 5,739.32 27,474,293.53 17,254,458.11 15,505,091.16 1,749,366.95 29,223,660.48 Portfolio BCRU Run Date.04/2812021-16:33 TC(PRF TCi 7.0 Repon Ver 7 3.6.1