Loading...
BCRUA_R-23-08-23-6A RESOLUTION NO. R-23-08-23-6A 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 June 30, 2023 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 23rd day of August, 2023. MATTHEW BAKER, President Brushy Creek Regional Utility Authority ATTE ANNE DUFFY, Secretar 0330 4634•A.48594514.5720 HIM i QUARTERLY INVESTMENT REPORT Brushy Creek RUA JUNE 30, 2023 �r MEEDER UHIBIT "A" M E E D E R A Fed Pause (For Now?) RATE EXPECTATIONS After a historic pace of rate hikes, for the first time this cycle, the Federal Open Market Committee voted to leave rates unchanged. The unanimous decision left the target range for 5.50% the federal funds rate at 5.00% - 5.25%, but throughout the month Jerome Powell messaged that more rate hikes are 5.00% likely needed to tame inflation. Labor market data released this month pointed to a still 4.50% resilient economy. The June jobs report saw another surprisingly high payroll number,with the US economy adding 4.00% 339,000 jobs in the month. Additionally, the increases were broad-based,with increases across different job categories. 3.50°i° p co {'3 co CY? C'') Cf) co '� V <t � d' �t d � tet' Although the unemployment rate increased to 3.7% N N N N N N N N NN N N CM N N N N at least partially due to more labor force participation.Job t > 0 C � i L 5 t) a > 0 P Y P P : � W 0 o 0 M v M ¢ M --� 5 v o a) openings also increased, signaling that for now, employers --� a cn 0 z 0 -5 61 2 d 2i -� Q 0 0 z o are still looking to add to their workforce. Initial jobless claims did continue to grind higher, evidencing maybe some early �lMedian Fed Dots ....Median Economist Forecast ■Fed Funds Futures signs of labor market weakness. Initial jobless claims averaged 258,000 in June, up from an average of 230,000 in SOURCE BLOOMBERG May. JOBLESS CLAIMS INCREASING Inflation data shows that,while annual figures continue to moderate, monthly figures point to some price stickiness. The US Initial Jobless Claims SA June Consumer Price Index (CPI) report showed that annual headline inflation was 4%, the lowest figure since March 290 2021. On a monthly basis, core inflation increased by 0.4% for 270 the third month in a row,which annualizes to a rate of 4.8%. Although inflation readings are firmly below the high figures 250 from 2022, if core inflation is still increasing at nearly 5% 230 annually, the Federal Reserve likely believes they have more 210kaw work to do. 190 170 N N N N N N N N N N N N M co co co co N N N N N N N N N N N N N N N N N N N N > U C -0 i i >+ C '' > U CII i >+ O z o -5 LL 2 Q Q rn 0 z 0 ul 2 Q 2i SOURCE:BLOOMBERG ��� MEEDER Short-term Rates Move Higher With still solid economic data and hawkish US Treasury Yield Curve commentary from Powell, markets ended June pricing in an additional rate hike by the end of the year. Short-term treasury yields are highly correlated with changes in monetary policy, and we saw treasury yields react to this renewed view on rates. The 2 Year US Treasury yield increased 0.50% to 4.90°/x, and the 5 Year US Treasury yield increased 0.41% to 4.16%. Long-term treasury rates are more reflective of the market's outlook on growth. The 10 Year US _ Treasury yield increased by just 0.20% to 3.84%, keeping the yield curve inversion at - . 1.06%. Outside of March 8th, this is the most the curve has been inverted this rate hiking cycle. 2.00 Even with an inverted yield curve signaling an economic slowdown,spreads on corporate bonds, commercial paper, municipal bonds, and agency bonds generally tightened over 14 the month. Some of the spread tightening was a continuation of the movement we saw after the debt ceiling debate was resolved. With spreads slightly below historic 0.00% averages,we will continue to look to add F v � 8 value by picking up incremental yield on high- 2} N M Y M quality bonds, including agency debt. Locking co in current yields and income levels will -June 30,2023 March 31,2023 June 30,2022 benefit portfolios when the yield curve SOURCE; BIOOMBERG eventually normalizes, and rates fall when this hiking cycle ends. Brushy Creek Regional Utility Authority (RUA), Texas Quarterly Investment Report April June 2023 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). Portfolio as ofMarch 31, 2023 Portfolio as of June 30, 2023 Beginning Book Value $ 159,583,976 Ending Book Value $ 144,451,624 Beginning Market Value $ 158,068,343 Ending Market Value $ 143,861,348 Investment Income for the period $ 1,585,285 Unrealized Gain/Loss $ (515,633) Unrealized Gain/Loss $ (590,276) Change in Unrealized Gain/Loss $ (74,643) WAM at Beginning Period Date' 128 days WAM at Ending Period Date' 98 days Change in Market Value' $ (14,206,995) Average Yield to Maturity for period 4.198% Average Yield 2 Year Treasury Note for period 4.260% Authorized by: a„� Karen Bondy, Gen Manager aso Head s, Senio ice President Brushy Creek RUA eeder Public Funds 1 WAM,represents weighted average maturity. 2 Change in Market Value" is required data,but will primarily reflect the receipt and expenditure of the Authority's funds from quarter to quarter. Your Portfolio M E E D E R As of June 30, 2023 Your Portfolio Statistics Your Asset Allocation Weighted Average Maturity 0.27 years e• • ■ Treasuries Weighted Average Yield (Alf Funds) 4.38% Bank & Pools ■Commercial Paper i ■ Agencies Your Maturity Distribution 90,000,000 80,000,000 82,690,232 70,000,000 v 60,000,000 • 50,000,000 N 40,000,000 0 30,000,000 20,000,000 10,000,000 43% Overnight 0-1 year 1-2 years 2-3 years 3-4 years 4-5 years Allocation Percentage Per Year Meader Public Funds MEEDER Brushy Creek Reg. Utility Auth 901 S.MoPac Suite 300 " `"'OMOi Portfolio Management Austin,TX 78746 Portfolio Summary - June 30, 2023 Par Market Book %of Days to YTM Investments Value Value Value Portfolio Tenn Maturity 365 Equiv_ BNY CASH 1,450,191.41 1,450.191.41 1,450,191.41 1.00 1 1 5.000 Commercial Paper Disc.-Amortizing 10,000,000.00 9,784,185.00 9,795,391.66 6.78 224 138 5.445 Federal Agency Coupon Securides 48,000,000.00 47,767,058.00 47,970,831.01 33.21 400 188 4.529 Treasury Coupon Securities 15,000.000.00 14,613,281.25 14,986,602.10 10.37 730 214 1.029 Treasury Discounts-Amortizing 10,000,000.00 9,935,431.20 9,937,407.16 6.88 181 47 5.050 TexSTAR 53,330,179.79 53,330,179.79 53,330,179.79 36.92 1 1 5.076 Money Market 2,744,923.53 2,744,923.53 2,744,923.53 1.90 1 1 5.410 Wells Fargo 4,236,097 40 4,236,097.40 4,236,097.40 2.93 1 1 1.000 144,761,392.13 143,861,347.58 144,451,624.06 100.00% 237 98 4.384 Investments Total Earnings June 30 Month Ending Fiscal Year To Date Current Year 538,127.83 3,979,321.98 The following reports are submitted in accordance with the Public Funds Investment Act(Texas Govt Code 2256). The reports also 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. art Karen Bondy,General Manag r Reporting period 06/0112023-06/3012023 Portfolio ECRU Data Updated.SET_BCRU:07/19/2023 08.57 AP Run Oate:07/1912023-08.58 PM(PRF PMI)7.3.0 Report Ver.7.3.6.1 Meeder Public Funds M E E D E R Brushy Creek Reg. Utility Auth 901 S.MoPac rusLic ruwoS te 300 Summary by Type Austin,TX78746 June 30, 2023 - Grouped by Fund Number of Par %of Average Average Days Security Type Investments Value Book Value Portfolio YTM 365 to Maturity Fund: Construction Funds Money Markel 1 2,744,923.53 2,744,923.53 1.90 5.410 1 Commercial Paper Disc.-Amortizing 1 5,000,000.00 4,828,458.33 3.34 5.740 230 TexSTAR 4 12.794,490.84 12,794,490.84 8.86 5.076 1 Wells Fargo 2 294,267.71 294,267.71 0.20 1.000 1 Subtotal 8 20,833,682.08 20,662,140.41 14.30 5.218 55 Fund: Construction Funds-2018 SWIFT TexSTAR 2 942,051.17 942,051.17 0.65 5.076 1 Subtotal 2 942,051.17 942,051.17 0.65 5.076 1 Fund: Construction Funds-2021 Federal Agency Coupon Securities 4 23,000,000.00 22,961,655.88 15.90 4.271 76 Commercial Paper Disc.-Amortizing 1 5,000,000.00 4,966,933.33 3.44 5.158 48 Treasury Discounts-Amortizing 1 10,000,000.00 9,937,407.16 6.88 5.050 47 TexSTAR 2 21,661,791.95 21,661,791.95 15.00 5.076 1 Subtotal 8 59,661,791.95 59,527,788.32 41.22 4.768 42 Fund: Construction Funds-2022 SWIFT Federal Agency Coupon Securities 2 25.000.000.00 25,009,175.13 17.31 4.766 290 TexSTAR 1 14.942.775.63 14,942,775.63 10.34 5.076 1 Subtotal 3 39,942,775.63 39,951,950.76 27.65 4.882 182 Fund: Escrow Funds TexSTAR 2 0.00 0.00 0.00 0.000 0 Subtotal 2 0.00 0.00 0.00 0.000 0 Fund: Escrow Funds-2018 BNY CASH 1 92.34 92.34 0.00 4.740 1 TexSTAR 2 161,310.14 161,31D.14 0.11 5.076 1 Portfolio l3CRU AP Run Dale:07119/2023 09:04 ST(PRF—ST)7 2.0 Report Ver.7.3.6.1 Brushy Creek Reg.Utility Auth Summary by Type Page 2 June 30,2023 Grouped by Fund Number of Par %.of Average Average Days Security Type Investments Value Book Value portfolio Y7M 365 to Matu Subtotal 3 161,402.48 161,402.48 0.11 5.076 1 Fund: Escrow Funds-2021 BNY CASH 2 1,450,099.07 1,450,099.07 1.00 5.000 1 Treasury Coupon Securities 1 15,000,000.00 14,986,602.10 10.37 1.029 214 Subtotal 3 16,450,099.07 16,436,701.17 11.37 1.380 195 Fund: Escrow Funds-2022 BNY CASH 1 0.00 0.00 0.00 0.000 0 Subtotal 1 0.00 0.00 0.00 0.000 0 Fund: Operating Funds TexSTAR 1 2,827,760.06 2,827,760.06 1.96 5 076 1 Wells Fargo 1 3,941,829.69 3,941,829.69 2.73 1 000 1 Subtotal 2 6,769,589.75 6,769,589.75 4.69 2.703 1 Total and Average 32 144,761,392.13 144,451,624.06 100.00 4.384 98 Portfolio BCRU AP Run Dale:07!1912023.09-04 ST(PRF_ST)7.2.0 Report Ver.7.3.6.1 Meeder Public Funds M E E D E R Brushy Creek Reg. Utility Auth 901 S.MoPac PUBLIC FUNDS Fund CON -Construction Funds Suite 300 Austin,TX 78746 Investments by Fund June 30, 2023 Purchase Current YTM yTM Maturity Days To CLISIP Investment 9 Issuer Date Book Value Par Value Market Value Rate 360 365 Date Maturity Commercial Paper Disc.-Amortizing 89119ABG2 10350 Toronto Dominion CP-Cedar Park 05/25/2023 4,828,458.33 5,000,000,00 4,819,915.00 5.370 5.661 5.739 02116/2024 230 Subtotal and Average 4,828,458.33 5,000,000.00 4,819,915.00 5.661 5.740 230 TexSTAR 2461110300 10252 TexStar Master 01/01/2018 7,425,803.42 7,425,803,42 7,425,803.42 5.076 5.006 5.076 1 246131030000 10006 TexSTAR-Cedar Park 10/15/2009 0.00 0.00 0.00 3.968 3.913 3.968 1 246141030000 10007 TexSTAR-Leander 10/15/2009 3,188,688.54 3,188,688.54 3,188,688.54 5.076 5.006 5.076 1 246161030000 10008 TexSTAR-Round Rock 10/1512009 2,179,998.88 2179,998.88 2,179,998.88 5.076 5.006 5.076 1 Subtotal and Average 12,794,490.84 12,794,490.84 12,794,490.84 5.007 5.076 1 Money Market 6095A 10315 NexBank ICS-Round Rock 09/05/2019 2,744,923.53 2,744,923.53 2,744,923.53 5.410 5.335 5.410 1 Subtotal and Average 2,744,923.53 2,744,923.53 2,744,923.53 5.336 5.410 1 Wells Fargo 8940 10204 Wells Fargo Bus Chkg-C Park 08/02/2016 2.45 2.45 2.45 1.000 0.986 1.000 1 8932 10205 Wells Fargo Bus Chkg-Leander 08/0112016 294,265.26 294,265.26 294,265.26 1.000 0.986 1.000 1 Subtotal and Average 294,267.71 294,267.71 294,267.71 0.986 1.000 1 Total Investments and Average 20,662,140.41 20,833,682.08 20,653,597.08 5.146 5.218 54 Portfolio 13CRU AP Run Date 0711912023-09:03 FI(PRF-F1)7.1.1 Report Ver 7.3.6 1 Fund CONI 8 -Construction Funds-2098 SWIFT Investments by Fund Page 2 June 30, 2023 Purchase Current yTM YTM Maturity Days To CUSIP Investment# Issuer Date Book Value Par Value Market Value Rate 360 365 Date Maturity TexSTAR 2461320180 10289 TexSTAR-Cedar Park 03/07/2019 512,844.82 512,844.82 512,844.82 5.076 5.006 5.076 1 2461420180 10290 TexSTAR-Leander 03/04/2019 429,206.35 429,206.35 429,206.35 5.076 5.006 5.076 1 Subtotal and Average 942,051.17 942,051.17 942,051.17 5.007 5.076 1 Total Investments and Average 942,051.17 942,051.17 942,051.17 5.007 5.076 1 Portfolio ECRU AP Run Dale:07/19/2023.09:03 FI(PRF_FI)7 1 1 Repon Ver.7.3.6.1 Fund CON21 -Construction Funds-2021 Investments by Fund Page 3 June 30, 2023 Purchase Current YTM YTM Maturity Days To CUSIP Investment# Issuer Date Book Value Par Value Market Value Rate 360 365 Date Maturity Commercial Paper Disc.-Amortizing 62479MW9 10349 MUFG Bank CP.Cedar Park 0211712023 4,966,933.33 5,000,000.00 4.964,270.00 5.087 5.158 0811812023 48 Subtotal and Average 4,966,933.33 5,000,000.00 4,964,270.00 5.088 5.158 48 Federal Agency Coupon Securities 3130ATGX9A 10340 FHLB Note-Cedar Park 09/2712022 6,499,362.09 6,500,000.00 6,478,131.40 4.300 4.283 4.342 0912612023 87 3130ATFF9 10338 FHLB Note-Leander 09/2012022 5,000.000.00 5,000,000.00 4,982,575.65 4.125 4.068 4.125 09/20/2023 81 3130ATGX9B 10341 FHLB Note-Leander 09/2712022 4.999,509.30 5,000,000.00 4,983,178.00 4.300 4.283 4.342 0912612023 87 3137EAEV7 10342 FHLMC Note-Cedar Park 09/28/2022 6,462,784.49 6,500,000.00 6,454,425.25 0.250 4.197 4.255 08/2412023 54 Subtotal and Average 22,961,655.88 23,000,000.00 22,898,310.30 4.212 4.271 76 Treasury Discounts-Amortizing 912796Z36 10348 T Bill-Cedar Park 0211712023 9,937,407.16 10,000,000.00 9,935,431.20 4.981 5.050 08/17/2023 47 Subtotal and Average 9,937,407.16 10,000,000.00 9,935,431.20 4.981 5.050 47 TexSTAR 2461120211 10334 TexSTAR-Cedar Park 02/01/2022 13,477,022.01 13,477,022.01 13,477,022.01 5.076 5.006 5.076 1 2461120210 10335 TexSTAR-Leander 02/0112022 8,184,769.94 8.184,769.94 8,184,769.94 5-076 5.006 5.076 1 Subtotal and Average 21,661,791.95 21,661,791.95 21,661,791.95 5.007 5.076 1 Total Investments and Average 59,527,788.32 59,661,791.95 59,459,803.45 4.703 4.768 41 Portfolio BCRU AP Run Date:07/19/2023 09:03 FI(PRF-FI)7 1 1 Report Ver 7 3.6.1 Fund CON22 -Construction Funds- 2022 SWIFT Investments by Fund Page 4 June 30, 2023 Purchase Current yTM yTM Maturity Days To CUSIP Investment# Issuer Date Book Value Par Value Market Value Rate 760 365 Date Maturtty Federal Agency Coupon Securities 3130ATVC8 10345 FHLB Note.Leander 01/30/2023 10,016,025.18 10,000,000.00 9,942,041.60 4.875 4.624 4.688 06/14/2024 349 3130ATUQB 10346 FHLB Note,Leander 01/31/2023 14,993,149.95 15,000,000.00 14,926,706.10 4.750 4.752 4.818 03/08/2024 251 Subtotal and Average 25,009,175.13 25,000,000.00 24,668,747.70 4.701 4.766 290 TexSTAR 2461110301 10347 TexSTAR-Leander 01/12/2023 14,942,775.63 14,942,775.63 14,942,775.63 5.076 5.006 5.076 1 Subtotal and Average 14,942,775.63 14,942,775.63 14,942,775.63 5.007 5.076 1 Total Investments and Average 39,951,950.76 39,942,775.63 39,811,523.33 4.815 4.882 182 Portfolio ECRU AP Run Date 0711912023•09:03 FI(PRF_FI)7.1.1 Report Ver.7.3.6.1 Fund ESC - Escrow Funds Investments by Fund Page 5 June 30, 2023 Purchase Current YTM yTM Maturity Days To CUSIP Investment# Issuer Dale Book Value Par Value Market Value Rate 380 365 Date Maturity TexSTAR 246122009001 10001 TexSTAR.Leander 1010112009 0.00 000 0 00 1 246122009002 10002 TexSTAR-Round Rock 10/01/2009 0.00 0.00 0.00 1.401 1.381 1.401 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 ECRU AP Run Date.07119!2023 09:03 FI(PRF_FI)7 1 1 Report Ver 7.3.6.1 Fund ESC18 - Escrow Funds -2018 Investments by Fund Page 6 June 30, 2023 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 99997 10270 BNY Cash-Cedar Park 10/0112022 92.34 9234 9234 4 740 4.675 4.740 1 Subtotal and Average 92.34 92.34 92.34 4.675 4.740 1 TexSTAR 2461220180 10284 TexSTAR-Cedar Park 02/1512019 161,310.14 161,310.14 161,310.14 5.076 5.006 5.076 1 2461220181 10285 TexSTAR-Leander 02/2812019 0.00 0.00 0,00 1 Subtotal and Average 161,310.14 161,310.14 161,310.14 5.007 5.076 1 Total Investments and Average 161,402.48 161,402.48 161,402.48 5.007 5.076 1 Portfolio BCRU AP Run Date 0711912023.09:03 FI(PRF_FI)7 1 1 Report Ver 7 3.6 1 Fund ESC21 - Escrow Funds -2021 Investments by Fund Page 7 June 30, 2023 Purchase Current YTM YTM Maturity Days To CUSIP Investment X Issuer Date Book Value Par Value Market Value Rate 360 365 Date Maturity BNY CASH 999910 10329 BNY Cash-Cedar Park 1010112022 1,065,649 75 1,065,649 75 1,065,649 75 5 000 4 931 5 000 1 999911 10330 BNY Cash-Leander 10101/2022 384,449.32 384,449.32 384,449.32 5.000 4.931 5.000 1 Subtotal and Average 1,450,099.07 1,450,099.07 1,450,099.07 4.932 5.000 1 Treasury Coupon Securities 91282CDVO 10332 T Note-Cedar Park 01/31/2022 14,986,602.10 15,000,000.00 14,613,261.25 0.875 1.015 1.029 01/3112024 214 Subtotal and Average 14,986,602.10 15,000,000.00 14,613,281.25 1.015 1.029 214 Total Investments and Average 16,436,701.17 16,450,099.07 16,063,380.32 1.361 1.380 195 Portfolio ECRU AP Run Date 07/1912023•09:03 FI(PRF_FI)7 1 1 Report Ver 7 3 6 1 Fund ESC22 - Escrow Funds -2022 Investments by Fund Page 8 June 30, 2023 Purchase Current YTM YTM Maturity Days To CUSIP Investment# Issuer Date Book Value Par Value Market Value Rate 360 365 Date Maturity BNY CASH 999912 10344 BNY Cash-Leander 11/29/2022 D.DO 000 coo 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.07/19[2023-09:03 FI(PRF FI)7 1 1 Repon Ver 7 3.6.1 Fund OPER -Operating Funds Investments by Fund Page 9 June 30, 2023 Purchase Current YTM YTM Maturity Days To CUSIP Investment# Issuer Date Book Value Par Value Market Value Rate 360 365 Date Maturity TexSTAR 2461111110 10254 TexStar Master 01/01/2018 2,827,760.06 2,827,760.06 2,827,760.06 5.076 5.006 5.076 1 Subtotal and Average 2,827,760.06 2,827,760.06 2,827,760.06 5.007 5.076 1 Wells Fargo 5125 10199 Wells Fargo Bus Chkg•Oper 05/26/2016 3,941,829.69 3,941,829.69 3,941,829.69 1.000 0.986 1.000 1 Subtotal and Average 3,941,829.69 3,941,829.69 3,941,829.69 0.986 1.000 1 Total Investments and Average 6,769,589.75 6,769,589.75 6,769,589.75 2.666 2.703 1 Portfolio BCRU AP Run Date:07119/2023-09:03 FI(PRF-Fl)7 1 1 Report Ver 7.3.6.1 Meeder Public Funds c M E E D E R Brushy Creek Reg. Utility Auth 901 S.MoPac ` '°""FUNDS Report suite 300 Cash Reconciliationp Austin,TX 78746 For the Period April 1, 2023 -June 30, 2023 Trans. Trans. Par Maturity Date Investment# Fund Type Security ID Value Security Description Date Purchases Interest Redemptions Cash 05/25/2023 10350 CON Pumhase 89119ASG2 5 000 000 00 TRDMCP 5 OM 5 37%Mat 02/1612024 -4,800,862.50 0.00 0.00 -4,800.862.50 06/13/2023 10337 CON21 Maturity 78009BTD4 5 000 000.00 RBCLE 5.OM 4 33%Mat 06/13/2023 06/1312023 0.00 0.00 5,000,000.00 5,000,000.00 06114(2023 10345 CON22 Interest 3130ATVC8 10 000 000.00 FHLBLE 10 OM 4.88%Mat. 06/1412024 0.00 293,854.17 0.00 293,854.17 Subtotal -4,800,862.50 293,854.17 5,000,000.00 492,991.67 Total -4,800,862.50 293,854.17 5,000,000.00 492,991.67 Portfolio BCRU AP Run Date 01!31/2023•10:51 AC(PRF AC)7.2 0 Report Vet 7 3-6 1 / ^ Meeder Public Funds {\\ M E E D E R Brushy Creek Reg. Utility Auth 901 S.MoPac PUBLIC FUNDS Purchases Report Suite 300 P Austin,TX 78746 Sorted by Fund - Issuer - April 1, 2023 -June 30, 2023 Sec. Original Purchase Principal Accrued interest Rate at Maturity Ending CUSIP Investment# Fund Type Issuer Par Value Date Payment Periods Purchased at Purchase Purchase Date YTM Book Value Construction Funds 89119ABG2 10350 CON ACP TRDMCP 5,000,000.00 05125/2023 02116-At Maturity 4,800.862.50 5.370 02/16/2024 5.661 4,828,458.33 Subtotal 5,000,000.00 4,800,862.50 0.00 4,828,458.33 Total Purchases 5,000,000.00 4,800,862.50 0.00 4,828,458.33 Portfolio ECRU AP Run Date 07131/2023•10.49 PU(PRF_PU)7 1 1 Report Ver 7 3.6.1 / A Meeder Publicop (\\` MEEDER Brushy Creek Reg. Utility Auth 401 S. MoPacac FUSLIC FUNDS MaturityRe ort suite 300 p Austin,TX 78746 Sorted by Maturity Date - Amounts due during April 1,2023-June 30,2023 Sec. Maturity Purchase Rate Book Value Maturity Net CUSIP Investment# Fund Type Issuer Par Value Date Date at Maturity at Maturity Interest Proceeds Income 780096TD4 10337 CON21 ACP RBCLE 5,000,000.00 06/13/2023 09/20/2022 4.330 5,000,000.00 000 5,000,000-00 0.00 Tota!Maturitles 5,000,000.00 5,000,000.00 0.00 5,000,000.00 0.00 Portfolio BCRU AP Run Dale:07/3112023-10:50 MA(PRF MA)7 1 1 Report Ver 7 3.6.1 Meeder Public Funds M E E D E R Brushy Creek Reg. Utility Auth 901 S MoPac / Suite 306 PUNK FUND{ Interest Earnings g Austin,TX 78746 Sorted by Fund - Fund - April 1, 2023 -June 30, 2023 Yield on Beginning Book Value Adjusted Interest Earnings Security Ending Beginning Ending 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 246161030000 10008 CON RRP 2,179,998.88 227,182.79 2,179,998.88 5.076 7.108 4,025.99 000 4,025.99 246141030000 10007 CON RRP 3,188,688.54 3,172,071.69 3,188,688.54 5.076 4.998 39,526 38 0 00 39,526.38 8932 10205 CON RR5 294,265.26 457,096.87 294,265.26 1.000 0.904 1.029.65 0.00 1,029.65 8940 10204 CON RR5 2.45 10,149,593.02 2.45 1.000 0.556 14,069 76 0.00 14,069.76 2461110300 10252 CON RRP 7,425,803.42 7,695,976.39 7,425,803.42 5.076 4.666 89.519 49 0 00 89.519.49 6095A 10315 CON RR4 2,744,923.53 4,884,707.80 2,744,923.53 5.410 4.945 60,215 73 0 00 60,215 73 89119ABG2 10350 CON ACP 5,000,000.00 0.00 4,828,458 33 02/16/2024 5.370 5.670 000 27,595.83 27,595 83 Subtotal 20,633,682.08 26,586,628.56 20,662,140.41 3.317 208,387.06 27,595.83 235,982.83 Fund:Construction Funds-2018 SWIFT 2461320180 10289 CON18 RRP 512,844.82 513,659 52 512,844.82 5.076 4.992 6,392.86 0.00 6,392.86 2461420180 10290 CON18 RRP 429,206.35 434.474.88 429,206 35 5.076 4.981 5,395.98 0.DO 5,395.98 Subtotal 942,051.17 948,134.46 942,051.17 4.987 11,788.84 6.00 11,788.84 Fund:Construction Funds-2021 2461120211 10334 CON21 RRP 13,477,022.01 15,883 516.80 13,477,022.01 5.076 4.377 173,335 81 0.00 173,335.81 2461120210 10335 CON21 RRP 8,184,769.94 14 366 345.12 8,184,769.94 5.076 3.150 112.837.77 0 00 112,831.77 3130ATGX9A 10340 CON21 FAC 6.500,000.00 6498686.65 6,499.362.09 09/26/2023 4 300 4 354 69,875 00 67544 70,550.44 3130ATGX913 10341 CON21 FAC 5,000,D00 00 4.998,989.73 4,999,509.30 09/26/2023 4.300 4.354 53,750 DO 519.57 54,269 57 3130ATFF9 10338 CON21 FAC 5 000,D00 00 5.000.000.00 5,000,000.00 09/20/2023 4.125 4.136 51,562 50 000 51,562 50 78DD9BTD4 10337 CON21 ACP 0 DO 4.956.098-61 0.00 06/1312023 4.330 4.429 000 43 901.39 43,901.39 3137EAEV7 10342 CON21 FAC 6,500,DDO.00 6,399.588-34 6,462,784.49 08/24/2023 0.250 4.215 4,06250 63.19615 67,258.65 912796Z36 10348 CON21 ATD 10.000,DOD.00 9,816,216.76 9,937,407.16 08/17/2023 4 952 000 121.190.40 121.190.40 62479MVJ9 10349 CON21 ACP 5 DOD.DOD 00 4.904,244-44 4,966,933.33 08/18/2023 5.127 000 6268889 62,688.89 Subtotal 59,661,791.95 72,823,686.45 59,527,788.32 4.230 465,423.58 292,171.84 757,595.42 Fund:Construction Funds-2022 SWIFT 2461110301 10347 CON22 RRP 14.942,775.63 14.758.607 90 14,942,775.63 5.D76 5-005 184.167 73 000 184,167 73 3130ATU08 10346 CON22 FAC 15,000,000.00 14,990.653.98 14,993,149.95 03/08/2024 4.750 4.833 178,125 00 2 495 97 180,620 97 Portfolio BCRU AP Run Date:07/3112023.10:47 IE(PRF IE)7 2.0 Report Ver.7.3.6.1 Brushy Creek Reg.Utility Auth Interest Earnings Page 2 April 1,2023-June 30,2023 Adjusted Interest Earnings Security Ending Beginning Ending Maturity Current Annualized Interest Amorti=Uonl Adjusted Interest CUSIP Investment fl Fund Type Par Value Book Value Book Value Date Rate Yield Earned Accretion Eamings Fund:Construction Funds-2022 SWIFT 3130ATVCB 10345 CON22 FAC 10.000.000 00 10,020,23004 10,016,025.18 06/14/2024 4 875 4 710 121.875.00 •4,204.86 117,670 14 Subtotal 39,942,775.63 39,769,491.92 39,951,950.76 4.866 484,167.73 -1,708.89 482,458.84 Fund:Escrow Funds-2018 2461220180 10284 ESC18 RRP 161,310.14 159,322.47 161,310.14 5.076 5.004 1,987.67 0.00 1,987.67 99997 10270 ESC18 LAI 9234 91.38 92.34 4.740 2.897 0.66 0.00 0.66 Subtotal 161,402.48 159,413.85 161,402.48 5.003 1,988.33 0.00 1,988.33 Fund:Escrow Funds-2021 999910 10329 ESC21 LAI 1.065.649 75 1,053,013.64 1,065,649.75 5 000 4 937 12,962.26 0.00 12 962 26 999911 10330 ESC21 LAI 384.449 32 368,925 74 384,449.32 5.000 5.080 4,672.11 0.00 4,67211 91282CDVO 10332 ESC21 TRC 15.000.000 00 14,980,904.86 14.986.602.10 01/31/2024 0 875 1 036 32.993.79 5.697-24 38.691.03 Subtotal 16,450,099.07 16,402,844.24 16,436,701.17 1.377 50,628.16 5,697.24 56,325.40 Fund:Operating Funds 5125 10199 OPER RR5 3,941,82969 445,68106 3,941,829.69 1-000 2.296 2,551.61 0.00 2.55161 2461111110 10254 OPER RRP 2,827,760 06 2,448,095.73 2,827,760.06 5.076 5-996 36,594.10 0.00 36,594.10 Subtotal 6,769,589.75 2,893,776.79 6,769,589.75 5.426 39,145.71 0.00 39,145.71 Total 144,761,392.13 159,583,976.21 144,451,624.06 3.960 1,261,529.35 323,756.02 1,585,285.37 Portfolio ECRU AP Run Date:07/31/2023•10:47 IE(PRF IE)7 2 0 Report Ver 7-3.6.1 Meeder Public Funds t M E E D E R Brushy Creek Reg. Utility Auth 901 S.Mopac '"""`""°' Amortization Schedule Suite 300 Austin,TX 78746 April 1, 2023 -June 30, 2023 - Sorted By Fund - Fund Investment# Maturity Date Beginning Par Value Amounts Amortised Purchase Original Premium Ending And Unamortized Amount Amortized Amt Amortized Amount Unamortized Issuer Fund Amort.Date Current Rate Principal or Discount Book Value As This Period Through 06130/2023 Through 0 613 012 02 3 Construction Funds 10350 CON 02116/2024 5,000,000.00 4,800,862.50 -199,137.50 4,828,458.33 0.00 27,595.83 27,595.83 -171,541.67 Toronto Dominion CP-Cedar Park 5.370 -199,137.50 Subtotal 4,800,862.50 -199,137.50 4,828,458.33 0.00 27,595.83 27,595.83 -171,541.67 -199,137.50 Construction Funds-2021 10340 CON21 09/2612023 6,500,000.00 6,497,305 75 -2,69425 6,499,362.09 1,380.90 675.44 2,056.34 -63791 FHLB Note-Cedar Park 4.300 -1,313.35 10341 CON21 09/26/2023 5,000,000.00 4.997.927.50 -2072.50 4,999,509.30 1,062.23 519.57 1,581.80 -490.70 FHLB Note Leander 4.300 -1,010.27 10342 CON21 08/24/2023 6,500,000.00 6,271,089 50 -228.91050 6,462,784.49 128,498 84 63,196.15 191.694.99 -37,215.51 FHLMC Note-Cedar Park 0.250 -100,411.66 10349 CON21 08/18/2023 5,000,000.00 4,874,622 22 -125,377.78 4,966,933.33 29,622 22 62,688.89 92,311.11 -33,066.67 MUFG Bank CP-Cedar Park -95,755.56 10337 CON21 06/13/2023 5,000,000 00 4,840,030 56 -159,969.44 0.00 116,068 05 43,901.39 159.969 44 0.00 Royal Bk Canada CP-Leander 4.330 -43,901.39 10348 CON21 08/17/2023 10,000,000.00 9.758.950 97 -241,049.03 9,937,407 16 57.265 79 121,190.40 178,456 19 -62,59284 T Bill-Cedar Park -183,78324 Subtotal 37,239,926.50 -760,073.50 32,865,996.37 333,898.03 292,171.84 626,069.87 -134,003.63 -426,175.47 Construction Funds-2022 SWIFT 10345 CON22 06/1412024 10,000,000 00 10,023,080 00 23,080.00 10,016,025.18 -2,849.96 -4,204.86 -7.05482 16,025.18 FHLB Note Leander 4.875 20,230 04 10346 CON22 03/08/2024 15,000,00000 14,988.99000 -11,010.00 14,993,149.95 1,663.98 2,495.97 4.159.95 -6.850.05 FHLB Note-Leander 4 750 -9.34602 Subtotal 25,012,070.00 12,070.00 25,009,175.13 -1,185.98 -1,708.89 -2,894.87 9,175.13 10,884.02 Escrow Funds-2021 10332 ESC21 01/31/2024 15,000,000 00 14.954,296 88 .45,703.12 14,986,602.10 26,607 98 5,697.24 32,305 22 13,397.90 T Note-Cedar Park 0875 19,095 14 Subtotal 14,954,296.88 -45,703.12 14,986,602.10 26,607.98 5,697.24 32,305.22 -13,397.90 -19,095.14 Portfolio BCRU AP Run Dale 0713112023.10:49 AS(PRFASM 7 2 1 Report Ver 7 3.6.1 Brushy Creek Reg.Utility Auth Amortization Schedule Page 2 April 1,2023-June 30,2023 Investment# Maturity Date Beginning Par Value Amounts Amortized Purchase Original Premium Ending And Unamortlzed Amount Amortized Amt Amortized Amount Unamortized Issuer Fund Amort.Date Current Rate Principal or Discount Book Value This Period Through OW3012023 Through 06130/2023 Total 82,007,155.88 -992,844.12 77,690,231.93 359,320.03 323,756.02 683,076.05 309,768.07 633,524.09 Portfolio ECRU AP Run Date 0713112023-10.49 AS(PRF_ASN)7 2 1 Report Ver 7 3.6.1 Meeder Public Funds M E E D E R Brushy Creek Reg. Utility Auth 901 S. MoPac '"""'"«°' te 300 Projected Cashflow Report Austin,TX78746 Sorted by Fund - For the Period July 1, 2023 -January 31, 2024 Projected Transaction Trans.Rate Investment# Fund Security 10 Type Issuer Par Value Original Cost Principal Interest Total Construction Funds-2021 08/17/2023 10348 CON21 912796Z36 Maturity T Bill Cedar Park 10,000,000.00 9,758,950.97 10,000,000.00 0.00 10,000,000 00 08/18/2023 10349 CON21 62479MVJ9 Maturity MUFG Bank CP-Cedar Park 5,000,000.00 4,874,622.22 5,000,000.00 0.00 5,000,000.00 08/2412023 10342 CON21 3137EAEV7 Maturity FHLMC Note-Cedar Park 6,500 000 00 6,271.089.50 6,500,000.00 8,125.00 6.508125.00 09/20/2023 10338 CON21 3130ATFF9 Maturity FHLB Note-Leander 5,000 000 00 5,000,000 00 5 000.000.00 103,12500 5,103 12500 09/26/2023 10340 CON21 3130ATGX9A Maturity FHLB Note Cedar Park 6 500 000 00 6.497.305.75 6,500,000.00 139,750 00 6,639,750.00 09/26/2023 10341 CON21 3130ATGX98 Maturity FHLB Note-Leander 5 000 000 00 4.997.927 50 5000,000.00 107 50000 5107 500.00 Total for Construction Funds-2021 38,000,000.00 37,399,895.94 38,000,000.00 358,500.00 38,358,500.00 Construction Funds-2022 SWIFT 09108/2023 10346 CON22 3130ATUQB Interest FHLB Note-Leander 000 000 000 356.250 00 356,250-00 12/14/2023 10345 CON22 3130ATVC8 Interest FHLB Note-Leander 000 000 000 243.750 00 243,750.00 Total for Construction Funds-2022 0.00 0.00 0.00 600,000.00 800,000.00 Escrow Funds -2021 07/31/2023 10332 ESC21 91282CDVO Interest T Note-Cedar Park 000 0.00 0 00 65.62500 65,62500 01/31/2024 10332 ESC21 91282CDVO Maturity T Note-Cedar Park 15,000 000 00 14,954,296.88 15,000,000.00 65,62500 15,065,625.00 Total for Escrow Funds-2021 15,000,000.00 14,954,296.88 15,000,000.00 131,250.00 15,131,250.00 GRAND TOTALS: 53,000,000.00 52,354,192.82 53,000,000.00 1,089,750.00 54,089,750.00 Portfolio BCRU AP Run Date 07/31f2023-10 51 PC(PRF_PC)7.2.0 Report Ver 7 3 6.1 Meeder Public Funds MEEDER Brushy Creek Reg. Utility Auth 901 S.MoPac Suite 300 PUBLIC.°M°s Texas Compliance Change in Val Report Austin,TX 78746 Sorted by Fund - April 1, 2023 -June 30, 2023 Beginning Ending 1V# Issuer Fund Purch Date Interest Accrual Book Value Book Value Beginning Purchases/ Ending .usip Par Value YTM Mat Date Interest Received Market Value Additions Redemptions Change in Value Market Value =und:Construction Funds 0006 TXSCP CON 10/15/2009 0.00 0.00 0.00 0.00 0.00 0.00 46131030000 0.00 0.000 / / 0.00 0.00 0.00 0.00 0.00 0.00 0007 TXSLE CON 10/15/2009 39,526.38 3,172,071.69 43,464.83 26,847.98 16,616.85 3,188,688.54 '46141030000 3.188.688 54 5.076 / / 39,526.38 3,172,071.69 43,464.83 26,847 98 16,616.85 3.188,688 54 0008 TXSRR CON 10/15/2009 4,025.99 227,182 79 2,238,299.40 285,483.31 1,952,816.09 2179.998.88 1.46161030000 2,179.998 88 5-076 / / 4,025.99 227,182 79 2.238,299.40 285.483.31 1,952,816.09 2.179,998.88 0204 WFBCCP CON 08/02/2016 14,069.76 10,149.593.02 14,069.76 10.163.660.33 -10.149,590.57 2.45 1940 245 1 000 / / 14,069.76 10,149,593.02 14,069.76 10.163.660.33 -10.149,590.57 2.45 0205 WFBCLE CON 08101/2016 1,029.65 457,096.87 5.294,883 82 5,457,715.43 -162,831.61 294,265.26 1932 294.265.26 1 000 / / 1,02965 457,096.87 5.294,883 82 5,457.715.43 -162,83161 294,265.26 0206 WFBCRR CON 08/01/2016 0.00 0.00 0,00 0.00 0.00 0.00 1916 0-00 0 000 1 1 0.00 0.00 0.00 0.00 0.00 0.00 0252 TXMAST CON 01101/2018 89,519.49 7,695,976.39 29,265,729.82 29,535,902.79 270,172.97 7.425,803 42 !461110300 7,425,803.42 5 076 1 / 89,519.49 7,695,976.39 29.265,729.82 29,535.902 79 -270,172.97 7,425,803.42 0314 NXMMRR CON 09/04/2019 0.00 0.00 0.00 0.00 0.00 0.00 1095 000 0.000 / / 0.00 0.00 0.00 0.00 0.00 0.00 0315 NICSRR CON 09105/2019 60,215.73 4,884,707.80 60,215.73 2.200.000.00 -2.139,784 27 2 744.923.53 ,095A 2,744,923.53 5-410 / / 60,215.73 4,684.707.80 60,215.73 2.200,000.00 -2.139,784.27 2344.923 53 0350 TRDMCP CON 05/25/2023 0.00 0.00 4.800.862.50 0.00 4,828,458.33 4828-45833 19119ABG2 5,000.000 00 5 661 02/16/2024 0.00 0.00 4.800,662.50 0.00 4,819,915.00 4.819.915 00 Sub Totals For:Fund:Construction Funds 208,387 00 26,586,628.56 41,717,525.86 47,669,609 84 -5,924,488.15 20 662.140 41 208.387.00 26,586,628.56 41,717,525.86 47,669.609.84 -5,933,031.48 20,653597 08 =und:Construction Funds- Portfolio BCRU tun pate,07/3112023-10:52 TC(PRF_TC)7.0 Report Ver 7.3.6.1 Brushy Creek Reg.Utility Auth Texas Compliance Change in Val Report Page 2 April 1,2023-June 30,2023 Beginning Ending 1V# Issuer Fund Purch Date Interest Accrual Book Value Book Value Beginning Purchases/ Ending :usip Par Value YTM Mat Date Interest Received Market Value Additions Redemptions Change in Value Market Value 0286 TXSCP CON17 02/04/2019 000 0.00 000 0.00 000 0.00 461320170 0.00 0.000 / / 000 0.00 000 0.00 000 0.00 0287 TXSLE CON17 02/0412019 0.00 0.00 0.00 0.00 0.00 0.00 461420170 0.00 0.000 1 / 0.00 0.00 0.00 0.00 0.00 0.00 0288 TXSRR CON17 02/0412019 0.00 0.00 0.00 0.00 0.00 0.00 461620170 0.00 0.000 / / 0.00 0.00 0.00 0.00 0.00 0.00 Sub Totals For:Fund:Construction Funds- 0.00 0.00 0.00 0.00 0.00 0.00 0.00 000 0.00 0.00 0.00 0.00 'und:Construction Funds- 0289 TXSCP CON18 03/07/2019 6,392.86 513,659.52 6,392.86 7,207.56 -81470 512,84482 461320180 512,844.82 5.076 1 / 6,392.86 513,659.52 6,392.86 7,207.56 -814.70 512.844.82 0290 TXSLE CON18 03/04/2019 5,395.98 434,474.88 5,39598 10,664.51 -5,268.53 429,206.35 461420180 429,206.35 5.076 11 5,395.98 434,474.88 5,395.98 10,664.51 -5,268.53 429,206.35 Sub Totals For:Fund:Construction Funds- 11,788.84 948 134.40 11,788.84 17.872.07 -6,083.23 942,051.17 11,788.84 948,134.40 11,788.84 17,872.07 -6,08323 942,051.17 -und:Construction Funds- 0334 TXSCP CON21 02/01/2022 173,335.81 15,883,516.80 5,544,623.37 7,951,11816 -2.406494.79 13,477,022.01 461120211 13,477,022.01 5.076 / / 173,335.81 15 883.516.80 5,544,623.37 7,951,118,16 -2.406 494.79 13,477,022.01 0335 TXSLE CON21 02/01/2022 112,837.77 14.366.34512 5,583,114.84 11,764.690.02 •6.18157518 8,184,769.94 461120210 8,184,769.94 5.076 / / 112,837.77 14 366.345 12 5,583.114.84 11,764,690.02 -6.181 575 18 8,184,769.94 0337 RBCLE CON21 09/20/2022 0.00 4.956.098 61 0.00 5,000,000.00 -4.956.098 61 0.00 8009BTD4 0.00 0.000 06/13/2023 0.00 4.948.905 00 0.00 5,000,000.00 -4.948.905.00 0 00 0338 FHLBLE CON21 09/2012022 51,562.50 5.000.000 00 0.00 000 0.00 5.000,000.00 130ATFF9 5,000,000.00 4.125 09/20/2023 0.00 4.983,803 40 0.00 0 00 -1,22775 4,982,575.65 0340 FHLBCP CON21 09/2712022 69,875.00 6,498,686 65 0.00 0.00 675.44 6,499.362.09 130ATGX9A 6,500,000.00 4.342 09/26/2023 0.00 6,482,445 71 0.00 0.00 -4.314.31 6,478.131.40 Portfolio ECRU tun Daw 07131/2023•10:52 TC(PRF TC)7 0 Report Ver.7 3 6 1 Brushy Creek Reg.Utility Auth Texas Compliance Change in Val Report Page 3 April 1,2023-June 30,2023 Beginning Ending 1v# Issuer Fund Purch Date Interest Accrual Book Value Book Value Beginning Purchases/ Ending usip Par Value YTM Mat Date Interest Received Market Value Additions Redemptions Change in Value Market Value 0341 FHLBLE CON21 09/2712022 53,750.00 4,998389.73 0.00 0.00 519.57 4,999,509.30 130ATGX98 5,000,000.00 4.342 09/26/2023 0.00 4,986,496.70 0.00 0.00 -3,318.70 4,983,178.00 0342 FHMCP CON21 09/28/2022 4,062.50 6,399,588.34 0.00 0.00 63,196.15 6,462,784.49 137EAEV7 6,500,000.00 4.255 08/24/2023 0.00 6,384,501.96 0.00 0.00 69,923.29 6,454,425.25 0348 TBCP CON21 02/17/2023 0.00 9,816,216.76 0.00 0.00 121,190.40 9,937,407.16 12796236 10,000,000.00 4.981 08/17/2023 0.00 9,822.690.00 0.00 0.00 112,741.20 9,935,431.20 0349 MUFGCP CON21 02/1712023 0.00 4,904,244.44 0.00 0.00 62,688.89 4,966,933.33 2479MVJ9 5,000,000.00 5.087 08/18/2023 0.00 4,898.985.00 0.00 0.00 65,285.00 4,964,270.00 Sub Totals For:Fund:Construction Funds- 465,423.58 72,823,686,45 11,127,738.21 24,715,808.18 -13,295,898.13 59,527,788.32 286,173.58 72,757,689.69 11,127,738.21 24,715,808.18 -13,297,886.24 59,459,803.45 :und:Construction Funds- 0345 FHLBLE CON22 01/30/2023 121,875.00 10,020,230.04 0.00 0.00 -4,204.86 10,016,025.18 130ATVCB 10,000,000.00 4.688 06114/2024 181,458.34 10,034,349.50 0.00 0.00 -92,307.90 9,942,041.60 0346 FHLBLE CON22 01/31/2023 178,125.00 14,990,653.98 0.00 0.00 2,495.97 14,993,149.95 130ATUQB 15,000,000.00 4.818 03/08/2024 0.00 14,981,833.35 0.00 0.00 -55,127.25 14,926,706.10 0347 TXSLE CON22 01/12/2023 184,167.73 14,758,607,90 184,167.73 0.00 184,167.73 14,942,775.63 461110301 14,942,775.63 5.076 / J 184,167.73 14,758,607.90 184,167.73 0.00 1B4,167.73 14,942,775.63 Sub Totals For:Fund:Construction Funds- 484,167 73 39,769,491.92 184,167.73 0.00 182,458.84 39,951,950.76 365,626-07 39.774.790.75 184,167.73 0.00 36,732.58 39,811,523.33 'und:Debt Service Funds 0003 TXSCP DS 10/01/2009 000 0.00 0.00 0.00 0.00 0.00 46131023000 0.00 0.000 11 0.00 0.00 0.00 0.00 0.00 0.00 0004 TXSLE DS 10/0112009 0.00 0 00 0.00 0,00 0.00 0.00 46141023000 0.00 0.000 ! 1 0.00 0.00 0.00 0.00 0.00 0.00 0005 TXSRR DS 10!01/2009 0.00 0.00 0.00 0.00 0.00 0.00 46161023000 0.00 0.000 // 0.00 0.00 0.00 0.00 0.00 0.00 Portfolio ECRU Wn pate:07131/2023-10:52 TC(PRF TC)7 0 Report Ver 7 3.6,1 Brushy Creek Reg.Utility Auth Texas Compliance Change in Val Report Page 4 April 1,2023-June 30,2023 Beginning Ending IV# Issuer Fund Purch Date Interest Accrual Book Value Book Value Beginning Purchases/ Ending usip Par Value YTM Mat Date Interest Received Market Value Additions Redemptions Change In Value Market Value 0253 TXMAST DS 01/01/2018 0.00 0.00 0.00 000 0.00 000 461110230 000 0.000 1 1 0.00 0.00 0.00 0.00 0.00 000 Sub Totals For:Fund:Debt Service 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 'und:Escrow Funds 0000 TXSCP ESC 10/01/2009 0.00 0.00 0.00 0.00 0.00 0.00 46122009000 000 0.000 1 1 0.00 0.00 0.00 0.00 0.00 0.00 0001 TXSLE ESC 10/0112009 0.00 0.00 0.00 0 00 0.00 0 00 46122009001 000 O.D00 / / 0.00 0.00 0.00 0 00 0.00 0 00 0002 TXSRR ESC 10/0112009 0.00 0.00 0.00 0 00 0.00 0 00 46122009002 0.00 0.000 / / 0.00 0.00 0.00 0.00 0.00 000 0267 CASHLE ESC 10/01/2022 0.00 0.00 0.00 0.00 0.00 0.00 9994 0.00 0.000 / / 0.00 0.00 0.00 0.00 0.00 0.00 0268 CASHRR ESC 10/01/2022 0.00 0.00 0.00 0.00 0.00 0.00 9995 0.00 0.000 / / 0.00 0.00 0.00 0.00 0.00 0.00 0283 CASHCP ESC 10/0112022 0.00 0.00 0.00 0.00 0.00 0.00 9998 000 0.000 ! ! 0.00 0.00 0.00 0.00 0.00 0.00 Sub Totals For:Fund:Escrow 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 'und:Escrow Funds-2017 0223 CASHCP ESC17 10/01/2022 0.00 0,00 0.00 0 00 0.00 0 00 9991 D.DO 0.000 1 / O.DO 0.00 0.00 D 00 0.00 D 00 0224 CASHLE ESC17 10/01/2022 0.00 0.00 0.00 0 00 0.00 0 DO 9992 0.00 0.000 / 1 0.00 0.00 0.00 0 00 0.00 0 DO 0225 CASHRR ESC17 10/01/2022 0.00 0.00 0.00 000 0.00 0D 9993 0.00 0.000 / / 0.00 000 0.00 O.DO O.OD 0.00 Portfolio BCRU 'un Date 07131/2023-10:52 TC(PRF TC)7.0 Report Ver.7.3.6.1 Brushy Creek Reg.Utility Auth Texas Compliance Change in Val Report Page 5 April 1,2023-June 30,2023 Beginning Ending 1V# Issuer Fund Purch Date Interest Accrual Book Value Book Value Beginning Purchases/ Ending usip Par Value YTM Mat Date Interest Received Market Value Additions Redemptions Change In Value Market Value 0280 TXSCP ESC17 01/30/2019 0.00 0.00 0.00 0.00 0.00 0.00 461220170 0.00 0.000 1 / 0.00 0.00 0.00 0.D0 0.00 0.00 0281 TXSLE ESC17 01/3012019 0.00 0.00 0.00 0.00 0.00 0.00 461220171 0.00 0.000 11 0.00 0.00 OM 0.00 0.00 0.00 0282 TXSRR ESC17 01/3012019 0.00 0.00 O.00 0.00 0.00 0.00 461220172 0.00 0.000 ! ! 0.00 0.00 0.00 0,00 0.00 0.00 Sub Totals For:Fund:Escrow Funds-2017 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 'und:Escrow Funds-2018 0269 CASHLE ESC18 10/01/2022 0.00 0.00 0.00 0.00 0.00 0.00 9996 0.00 0.000 / / 0.00 0.00 0.00 0.D0 0.00 0.D0 0270 CASHCP E5C18 10/0112022 0.66 91.38 0.96 0.D0 0.96 92.34 9997 92.34 4.740 11 0.96 91.38 0.96 0.00 0.96 92.34 0284 TXSCP ESC18 02/1512019 1,987.67 159,322.47 1,987.67 0.00 1,987.67 161,310.14 461220180 161,310.14 5.076 11 1,987.67 159,322.47 1,987.67 0.00 1,987.67 161,310.14 0285 TXSLE ESC18 02/2812019 0.00 0.00 0.00 0.00 0.00 0.00 461220181 0.00 0.000 11 0.00 0.00 0.00 0.00 0.00 0.00 Sub Totals For:Fund:Escrow Funds-2018 1,988.33 159,413.85 1,988.63 0.00 1,988.63 161,402.48 1,988.63 159,413.85 1,988.63 0.00 1,988.63 161,402.48 und:Escrow Funds-2021 0329 CASHCP ESC21 10/01/2022 12,962.26 1,053,013.64 12,636.11 0.00 12,636.11 1,065,649.75 99910 1,065,649.75 5.000 11 12,636.11 1,053,013.64 12,636.11 0.00 12,636.11 1,065,649.75 ?330 CASHLE ESC21 10101/2022 4,672.11 368.925.74 15,523,58 0.00 15,523.58 384,449.32 99911 384,449.32 5.000 / / 15,523.58 368,925.74 15,523.58 0.00 15,523.58 384,449.32 0332 TNOTCP ESC21 01/31/2022 32,993.79 14,980,904.86 0.00 0.00 5,697.24 14,986,602.10 1282CDVO 15,000,00ozo 1.029 01131/2024 0.00 14,525,970.00 0.00 0.00 87,311.25 14,613,281.25 Portfolio BCRU un Date:0713112023.10:52 TC(PRF TC)7.0 Report Ver 7,3.6 1 Brushy Creek Reg.Utility Auth Texas Compliance Change in Val Report Page 6 April 1,2023-June 30,2023 Beginning Ending Iv# Issuer Fund Purch Date Interest Accrual Book Value Book Value Beginning Purchases/ Ending usip Par Value YTM Mat Date Interest Received Market Value Additions Redemptions Change in Value Market Value Sub Totals For:Fund:Escrow Funds-2021 50,628.16 16,402,844.24 28,159.69 0.00 33,856 93 16,436,701 17 28,159.69 15,947,909.38 28,159.69 0.00 115,470.94 16,063,380.32 'und:Escrow Funds-2022 D344 CASHLE ESC22 11/2912022 0.00 0.00 0.00 0.00 0.00 0.00 99912 0.00 0.000 1 / 0.00 0.00 0.00 0.00 0.00 0.00 Sub Totals For:Fund:Escrow Funds-2022 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 'und:Operating Funds 0199 WFBCOP OPER 05/2612016 2,551.61 445,681.06 33,713,504.44 30,217,355.81 3,496,14863 3,941,829-69 125 3,941,829.69 1.000 / / 2,551.61 445,681.06 33,713,504.44 30,217,355.81 3,496,148.63 3,941,829.69 ?254 TWAST OPER 01/01/2018 36,594.10 2,448,095.73 5,549,410,07 5,169,745.74 379,664.33 2,827,760.06 461111110 2,827,760.06 5.076 11 36,594.10 2,448,095.73 5,549,410,07 5,169,745.74 379,664.33 2,827,760.06 Sub Totals For.Fund:Operating Funds 39,145.71 2,893,776.79 39,262,914.51 35,387,101.55 3,875,812.96 6,769,589.75 39,145.71 2,893,776.79 39,262,914.51 35,387,101.55 3,875,812.96 6,769,589.75 Report Grand Totals: 1,261,529.35 159,583,976.21 92,334,283.47 107,790,391.64 -15,132,352.15 144,451,624.06 941,269.52 159,068,343.42 92,334,283.47 107,790,391.64 -15,206,995.84 143,861,347.58 Portfolio BCRU un Dale,07/3112023-10:52 TC{PRF TC)7.0 Report Ver 7 3.6.1 Disclosures Q MEEDER Meeder Public Funds, Inc., is a registered investment adviser with the Securities and Exchange Commission (SEC) under the Investment Advisers Act of 1940. Registration with the SEC does not imply a certain level of skill or training. The opinions expressed in this presentation are those of Meeder Public Funds, Inc. The material presented has been derived from sources considered to be reliable, but the accuracy and completeness cannot be guaranteed. Meeder provides monthly statements for its investment management clients to provide information about the investment portfolio. The information should not be used for audit or confirmation purposes. Please review your custodial statements and report any inaccuracies or discrepancies. Certain information and data have been supplied by unaffiliated third parties. Although Meeder believes the information is reliable, it cannot warrant the accuracy of information offered by third parties. Market value may reflect prices received from pricing vendors when current market quotations are not available. Prices may not reflect firm bids or offers and may differ from the value at which the security can be sold. Statements may include positions from unmanaged accounts provided for reporting purposes. Unmanaged accounts are managed directly by the client and are not included in the accounts managed by the investment adviser. This information is provided as a client convenience and the investment adviser assumes no responsibility for performance of these accounts or the accuracy of the data reported. Investing involves risk. Past performance is no guarantee of future results. Debt and fixed income securities are subject to credit and interest rate risk. The investment return and principal value of an investment will fluctuate so that an investors shares, when redeemed, may be worth more or less than their original cost. Current performance may be lower or higher than the performance data quoted. Investment advisory services are provided through Meeder Public Funds, Inc. Please contact us if you would like to receive a copy of our current ADV disclosure brochure or privacy policy. Meeder Public Funds Barton Oaks Plaza 1 901 S. MoPac Expy Suite 300 Austin, Texas 78746 866.633.3371