Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
BCRUA-2024-015 - 8/28/2024
RESOLUTION NO. BCRUA-2024_fJ6"� 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 .lune 30, 2024 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 August, 2024. NA' LE TROMPS N, President Brushy Creek Regional Utility Authority ATTEST: R E FLORES, 033D.4634-A 48604835-0808 Quarterly Investment Report BRUSHY CREEK RUA AS OF JUNE 30, 2024 Exhibit "A" 2 OBSERVATIONS AND EXPECTATIONS •U.S. economic growth should slow in the second half of 2024, but not be negative •The unemployment rate pushed above 4% in May from the cycle low of 3.4% •Fed Funds futures are pointing to two .25% cuts this year and four next year •Intermediate-term rates have increased this year, but are lower than last year’s peak Expected Downshift in Economic Growth •Economists surveyed by Bloomberg are expecting growth to slow in the coming quarters. •Higher inflation and interest rates have put a crimp in consumer spending. 6.2% 3.3% 7.0% -2.0% -0.6% 2.7%2.6%2.2%2.1% 4.9% 3.4% 1.3%2.0%1.6%1.6%1.8% -3% -2% -1% 0% 1% 2% 3% 4% 5% 6% 7% 8% Q2 2021 Q3 2021 Q4 2021 Q1 2022 Q2 2022 Q3 2022 Q4 2022 Q1 2023 Q2 2023 Q3 2023 Q4 2023 Q1 2024 Q2 2024 Q3 2024 Q4 2024 Q1 2025 QoQ GDP Estimates SOURCE: BLOOMBERG, BUREAU OF ECONOMIC ANALYSIS, 3 The Unemployment Rate Climbed Above 4% •The U.S. just finished its second longest streak of having the unemployment rate below 4%. •The Federal Reserve and most economists expect the unemployment rate to push higher with job growth slowing later this year. The Fed vs. The Market •The Federal Reserve is expecting one .25% cut this year to the Fed Funds Rate and four next year. •The Fed Funds futures market is expecting two .25% cuts this year and four next year to push the Fed Funds rate down to 3.97% from its current rate of 5.38% 8 35 20 27 4 13 27 0 5 10 15 20 25 30 35 40 19471950195319561959196219651968197119741977198019831986198919921995199820012004200720102013201620192022Number of Consecutive Months Below 4% Unemployment SOURCE: BLOOMBERG, BUREAU OF LABOR STATISTICS 5.38% 4.98% 3.97% 3.0% 3.5% 4.0% 4.5% 5.0% 5.5% 6.0% Dec-23 Jan-24 Feb-24 Mar-24 Apr-24 May-24 Jun-24 Current Fed Funds Rate vs. Dec 2024 Fed Funds Futures Rate vs. Dec 2025 Fed Funds Futures Rate Fed Funds Rate Fed Funds Dec 2024 Fed Funds Dec 2025 SOURCE: BLOOMBERG 4 Intermediate-Term Rates Higher In 2024 •Both the 2-year and 5-year U.S. Treasury rates had their cycle peaks last October at 5.22% and 4.96%, respectively. •Intermediate-term U.S. Treasury rates have climbed higher this year as market participants realized inflation remains sticky and Fed will cut the Fed Funds rate fewer times than was anticipated at the start of 2024. Takeaways •With intermediate-term interest rates near their highest levels since 2007, locking in those yields will most likely prove prudent. •It will be interesting to observe Federal Reserve policy later this year as inflation probably remains above their target, with unemployment increasing. 3.70% 3.90% 4.10% 4.30% 4.50% 4.70% 4.90% 5.10% Dec-23 Jan-24 Feb-24 Mar-24 Apr-24 May-24 Jun-24 YTD 2Y and 5Y Treasury Rates 2Y 5Y SOURCE: BLOOMBERG BRUSHY CREEK RUA | JUNE 30, 2024 Compliance Certification The undersigned acknowledge they have reviewed this quarterly investment report for the period ending June 30, 2024. Officials designated as investment officers by this entity’s Investment Policy attest that all investments comply with the Texas Public Funds Investment Act and this entity’s Investment Policy. Sam Roberts, P.E., General Manager BRUSHY CREEK RUA | JUNE 30, 2024 6 Contents Portfolio Statistics 7 Quarterly Portfolio Summary 8 Quarterly Portfolio Summary By Fund 9 Portfolio Overview 10 Summary by Type 11 Position Statement 14 Cash Reconciliation Report 19 Transaction Statement 20 Amortization Schedule 21 Accrued Interest Schedule 22 Earnings by Fund 25 Projected Cashflows 28 Change in Value 29 7 Portfolio Statistics Par Value $114,397,070 Principal Cost $113,590,932 Book Value $114,190,299 Market Value $114,164,798 Unrealized Gain/Loss ($25,501) Accrued Interest $163,340 Portfolio Position Sector AllocationMaturity Distribution • 1 Money Market Funds 71.99%• 1 Commercial Paper 20.84%• 1 U.S. Agencies 6.55%• 1 Bank Deposits 0.63% 5.29 Average Yield 0.07 Weighted Average Maturity (Years) 0.07 Portfolio Effective Duration (Years) 0.07 Weighted Average Life (Years) AA Average Credit Rating BRUSHY CREEK RUA JUNE 30, 2024 BRUSHY CREEK RUA | JUNE 30, 2024 8 Quarterly Portfolio Summary This quarterly report is prepared in compliance with the Investment Policy and the Strategy of this entity and the Public Funds Investment Act (Chapter 2256, Texas Government Code). Portfolio as of June 30, 2024 BEGINNING BOOK VALUE $119,104,545.27 BEGINNING MARKET VALUE $119,059,751.59 UNREALIZED GAIN/(LOSS)($44,793.68) WEIGHTED AVERAGE MATURITY (YEARS)0.13 WEIGHTED AVERAGE YIELD 4.36 ENDING BOOK VALUE $114,190,299.01 ENDING MARKET VALUE $114,164,798.47 INVESTMENT INCOME FOR THE PERIOD $1,275,477.41 UNREALIZED GAIN/(LOSS)($25,500.54) CHANGE IN UNREALIZED GAIN/(LOSS)$19,293.14 WEIGHTED AVERAGE MATURITY (YEARS)0.07 WEIGHTED AVERAGE YIELD 5.29 Portfolio as of March 31, 2024 BRUSHY CREEK RUA | JUNE 30, 2024 9 PORTFOLIO MARKET VALUE BY FUND 03/31/2024 06/30/2024 CHANGE INTEREST EARNED CEDAR PARK-ESFD23 78,572.08 0.00 -78,572.08 0.00 CEDAR PARK-ESFD23B 100.00 100.00 0.00 0.00 CONSTRUCTION FUNDS 3,190,003.29 2,492,372.12 -697,631.17 26,904.93 CONSTRUCTION FUNDS 2021 - CEDAR PARK 34,255,314.10 33,786,787.02 -468,527.08 418,331.37 CONSTRUCTION FUNDS 2021 - LEAN- DER 1,186,769.01 0.00 -1,186,769.01 2,865.79 CONSTRUCTION FUNDS 2023 - CEDAR PARK 7,578,003.97 7,206,738.85 -371,265.12 65,906.13 CONSTRUCTION FUNDS 2023 - ROUND ROCK 15,583,406.50 14,983,966.55 -599,439.95 137,736.01 CONSTRUCTION FUNDS LEANDER 2009 2,802,718.09 1,075,366.67 -1,727,351.42 17,791.50 CONSTRUCTION FUNDS-2018 SWIFT 93,287.31 32,802.57 -60,484.74 582.06 CONSTRUCTION FUNDS-2022 SWIFT 35,947,870.77 36,148,164.39 200,293.62 347,737.72 ESCROW FUNDS 2018 168,376.60 170,614.34 2,237.74 1,503.54 ESCROW FUNDS 2021 - CEDAR PARK 14,396,165.96 14,490,554.39 94,388.43 211,183.29 ESCROW FUNDS 2021 - LEANDER 1,705.63 6.76 -1,698.87 14.24 OPERATING FUNDS 3,408,081.56 3,777,224.81 369,143.25 44,920.82 ROUND ROCK ESFD23B 100.00 100.00 0.00 0.00 ROUND ROCK-ESFD23 369,276.72 0.00 -369,276.72 0.00 TOTAL 119,059,751.59 114,164,798.47 -4,894,953.12 1,275,477.41 Quarterly Portfolio Summary By Fund BRUSHY CREEK RUA | JUNE 30, 2024 10 Portfolio Overview SECURITY TYPE PAR VALUE MARKET VALUE BOOK VALUE % OF PORTFOLIO DAYS TO MATURITY YIELD Bank Deposits 713,596.81 713,596.81 713,596.81 0.63%1 1.09 Money Market Funds 82,183,472.77 82,183,472.77 82,183,472.77 71.99%1 5.30 Commercial Paper 24,000,000.00 23,793,753.89 23,793,753.89 20.84%58 5.53 U.S. Agencies 7,500,000.00 7,473,975.00 7,499,475.54 6.55%194 4.82 TOTAL 114,397,069.58 114,164,798.47 114,190,299.01 100.00%26 5.29 CASH AND ACCRUED INTEREST Purchased Accrued Interest 13,027.08 13,027.08 TOTAL CASH AND INVESTMENTS 114,397,069.58 114,177,825.55 114,203,326.09 26 5.29 TOTAL EARNINGS CURRENT QUARTER 1,275,477.41 BRUSHY CREEK RUA | JUNE 30, 2024 11 Summary by Type SECURITY TYPE # OF SECURITIES PAR VALUE BOOK VALUE % OF PORTFOLIO YIELD DAYS TO FINAL MATURITY CEDAR PARK-ESFD23B Bank Deposits 1 100.00 100.00 0.00 0.00 1 TOTAL 1 100.00 100.00 0.00 0.00 1 CONSTRUCTION FUNDS Money Market Funds 1 2,492,372.12 2,492,372.12 2.18 5.31 1 TOTAL 1 2,492,372.12 2,492,372.12 2.18 5.31 1 CONSTRUCTION FUNDS 2021 - CEDAR PARK Bank Deposits 1 300.53 300.53 0.00 1.06 1 Money Market Funds 1 9,992,732.60 9,992,732.60 8.74 5.31 1 Commercial Paper 4 24,000,000.00 23,793,753.89 20.81 5.53 58 TOTAL 6 33,993,033.13 33,786,787.02 29.59 5.47 41 CONSTRUCTION FUNDS 2023 - CEDAR PARK Money Market Funds 1 7,206,738.85 7,206,738.85 6.30 5.31 1 TOTAL 1 7,206,738.85 7,206,738.85 6.31 5.31 1 CONSTRUCTION FUNDS 2023 - ROUND ROCK Money Market Funds 1 14,983,966.55 14,983,966.55 13.10 5.31 1 TOTAL 1 14,983,966.55 14,983,966.55 13.12 5.31 1 CONSTRUCTION FUNDS LEANDER 2009 Money Market Funds 1 1,075,366.67 1,075,366.67 0.94 5.31 1 TOTAL 1 1,075,366.67 1,075,366.67 0.94 5.31 1 CONSTRUCTION FUNDS-2018 SWIFT Money Market Funds 1 32,802.57 32,802.57 0.03 5.31 1 TOTAL 1 32,802.57 32,802.57 0.03 5.31 1 BRUSHY CREEK RUA | JUNE 30, 2024 12 Summary by Type SECURITY TYPE # OF SECURITIES PAR VALUE BOOK VALUE % OF PORTFOLIO YIELD DAYS TO FINAL MATURITY CONSTRUCTION FUNDS-2022 SWIFT Bank Deposits 1 1,212.47 1,212.47 0.00 1.09 1 Money Market Funds 1 36,146,951.92 36,146,951.92 31.61 5.31 1 TOTAL 2 36,148,164.39 36,148,164.39 31.66 5.31 1 ESCROW FUNDS 2018 Bank Deposits 1 525.81 525.81 0.00 0.00 1 Money Market Funds 1 170,088.53 170,088.53 0.15 5.31 1 TOTAL 2 170,614.34 170,614.34 0.15 5.30 1 ESCROW FUNDS 2021 - CEDAR PARK Money Market Funds 1 7,016,579.39 7,016,579.39 6.14 5.19 1 U.S. Agencies 1 7,500,000.00 7,499,475.54 6.68 4.82 194 Receivable 1 29,885.08 29,885.08 0.03 0.00 0 TOTAL 2 14,516,579.39 14,516,054.93 12.69 5.00 102 ESCROW FUNDS 2021 - LEANDER Bank Deposits 1 6.76 6.76 0.00 0.00 1 TOTAL 1 6.76 6.76 0.00 0.00 1 OPERATING FUNDS Bank Deposits 1 711,351.24 711,351.24 0.62 1.09 1 Money Market Funds 1 3,065,873.57 3,065,873.57 2.68 5.31 1 TOTAL 2 3,777,224.81 3,777,224.81 3.31 4.52 1 ROUND ROCK ESFD23B Bank Deposits 1 100.00 100.00 0.00 0.00 1 TOTAL 1 100.00 100.00 0.00 0.00 1 BRUSHY CREEK RUA | JUNE 30, 2024 13 Summary by Type SECURITY TYPE # OF SECURITIES PAR VALUE BOOK VALUE % OF PORTFOLIO YIELD DAYS TO FINAL MATURITY GRAND TOTAL 22 114,397,069.58 114,190,299.01 100.00 5.29 26 BRUSHY CREEK RUA | JUNE 30, 2024 14 Position Statement CUSIP DESCRIPTION TRADE DATE SETTLE DATE PAR VALUE PRINCIPAL COST PURCHASED INTEREST TOTAL COST YIELD MATURITY DATE DAYS TO MATURITY MARKET PRICE MARKET VALUE UNREALIZED GAIN/LOSS BOOK VALUE % OF MV MOODY'S S&P RATING CEDAR PARK- ESFD23B BANK DEPOSITS CCYUSD Cash 06/30/2024 06/30/2024 100.00 100.00 0.00 100.00 0.00 1 1.00 100.00 0.00 100.00 0.00 Aaa AAA BANK DEPOSITS TOTAL 100.00 100.00 0.00 100.00 0.00 1 1.00 100.00 0.00 100.00 0.00 Aaa AAA CEDAR PARK- ESFD23B TOTAL 100.00 100.00 0.00 100.00 0.00 1 1.00 100.00 0.00 100.00 0.00 Aaa AAA CONSTRUCTION FUNDS MONEY MARKET FUNDS TEXSTAR-MC TexStar Master Construction 06/30/2024 06/30/2024 2,492,372.12 2,492,372.12 0.00 2,492,372.12 5.31 1 1.00 2,492,372.12 0.00 2,492,372.12 2.18 NA MONEY MARKET FUNDS TOTAL 2,492,372.12 2,492,372.12 0.00 2,492,372.12 5.31 1 1.00 2,492,372.12 0.00 2,492,372.12 2.18 NA CONSTRUCTION FUNDS TOTAL 2,492,372.12 2,492,372.12 0.00 2,492,372.12 5.31 1 1.00 2,492,372.12 0.00 2,492,372.12 2.18 NA CONSTRUCTION FUNDS 2021 - CEDAR PARK BANK DEPOSITS 1550578940CP Wells Fargo Analyzed Busi- ness Checking Plus PF - C 06/30/2024 06/30/2024 300.53 300.53 0.00 300.53 1.06 1 1.00 300.53 0.00 300.53 0.00 NA BANK DEPOSITS TOTAL 300.53 300.53 0.00 300.53 1.06 1 1.00 300.53 0.00 300.53 0.00 NA MONEY MARKET FUNDS TEXSTAR-CP TexStar Cedar Park 06/30/2024 06/30/2024 9,992,732.60 9,992,732.60 0.00 9,992,732.60 5.31 1 1.00 9,992,732.60 0.00 9,992,732.60 8.75 NA MONEY MARKET FUNDS TOTAL 9,992,732.60 9,992,732.60 0.00 9,992,732.60 5.31 1 1.00 9,992,732.60 0.00 9,992,732.60 8.75 NA COMMERCIAL PAPER 55607KH17 MACQUARIE BNK 08/01/24 01/25/2024 01/31/2024 7,500,000.00 7,301,750.00 0.00 7,301,750.00 5.34 08/01/2024 32 99.55 7,466,416.67 0.00 7,466,416.67 6.54 P-1 A-1 89233GH90 TOYOTA MOTOR CRD 08/09/24 11/14/2023 11/16/2023 5,000,000.00 4,794,929.17 0.00 4,794,929.17 5.73 08/09/2024 40 99.40 4,970,045.83 0.00 4,970,045.83 4.35 P-1 A-1+ BRUSHY CREEK RUA | JUNE 30, 2024 15 Position Statement CUSIP DESCRIPTION TRADE DATE SETTLE DATE PAR VALUE PRINCIPAL COST PURCHASED INTEREST TOTAL COST YIELD MATURITY DATE DAYS TO MATURITY MARKET PRICE MARKET VALUE UNREALIZED GAIN/LOSS BOOK VALUE % OF MV MOODY'S S&P RATING 78015CHC9 ROYAL BK CA NYBR 08/12/24 11/14/2023 11/16/2023 6,500,000.00 6,233,337.50 0.00 6,233,337.50 5.66 08/12/2024 43 99.36 6,458,519.17 0.00 6,458,519.17 5.66 P-1 A-1+ 62479LLF0 MUFG BANK NY 11/15/24 05/15/2024 05/16/2024 5,000,000.00 4,864,783.33 0.00 4,864,783.33 5.47 11/15/2024 138 97.98 4,898,772.22 0.00 4,898,772.22 4.29 P-1 A-1 COMMERCIAL PAPER TOTAL 24,000,000.00 23,194,800.00 0.00 23,194,800.00 5.53 58 99.14 23,793,753.89 0.00 23,793,753.89 20.84 P-1 AA CONSTRUCTION FUNDS 2021 - CEDAR PARK TOTAL 33,993,033.13 33,187,833.13 0.00 33,187,833.13 5.47 41 70.12 33,786,787.02 0.00 33,786,787.02 29.59 AA CONSTRUCTION FUNDS 2023 - CEDAR PARK MONEY MARKET FUNDS TEXSTAR-CP TexStar Cedar Park 06/30/2024 06/30/2024 7,206,738.85 7,206,738.85 0.00 7,206,738.85 5.31 1 1.00 7,206,738.85 0.00 7,206,738.85 6.31 NA MONEY MARKET FUNDS TOTAL 7,206,738.85 7,206,738.85 0.00 7,206,738.85 5.31 1 1.00 7,206,738.85 0.00 7,206,738.85 6.31 NA CONSTRUCTION FUNDS 2023 - CEDAR PARK TOTAL 7,206,738.85 7,206,738.85 0.00 7,206,738.85 5.31 1 1.00 7,206,738.85 0.00 7,206,738.85 6.31 NA CONSTRUCTION FUNDS 2023 - ROUND ROCK MONEY MARKET FUNDS TEXSTAR-RR TexStar Round Rock 06/30/2024 06/30/2024 14,983,966.55 14,983,966.55 0.00 14,983,966.55 5.31 1 1.00 14,983,966.55 0.00 14,983,966.55 13.12 NA MONEY MARKET FUNDS TOTAL 14,983,966.55 14,983,966.55 0.00 14,983,966.55 5.31 1 1.00 14,983,966.55 0.00 14,983,966.55 13.12 NA CONSTRUCTION FUNDS 2023 - ROUND ROCK TOTAL 14,983,966.55 14,983,966.55 0.00 14,983,966.55 5.31 1 1.00 14,983,966.55 0.00 14,983,966.55 13.12 NA CONSTRUCTION FUNDS LEANDER 2009 MONEY MARKET FUNDS TEXSTAR-LD TexStar Leander 06/30/2024 06/30/2024 1,075,366.67 1,075,366.67 0.00 1,075,366.67 5.31 1 1.00 1,075,366.67 0.00 1,075,366.67 0.94 NA BRUSHY CREEK RUA | JUNE 30, 2024 16 Position Statement CUSIP DESCRIPTION TRADE DATE SETTLE DATE PAR VALUE PRINCIPAL COST PURCHASED INTEREST TOTAL COST YIELD MATURITY DATE DAYS TO MATURITY MARKET PRICE MARKET VALUE UNREALIZED GAIN/LOSS BOOK VALUE % OF MV MOODY'S S&P RATING MONEY MARKET FUNDS TOTAL 1,075,366.67 1,075,366.67 0.00 1,075,366.67 5.31 1 1.00 1,075,366.67 0.00 1,075,366.67 0.94 NA CONSTRUCTION FUNDS LEANDER 2009 TOTAL 1,075,366.67 1,075,366.67 0.00 1,075,366.67 5.31 1 1.00 1,075,366.67 0.00 1,075,366.67 0.94 NA CONSTRUCTION FUNDS-2018 SWIFT MONEY MARKET FUNDS TEXSTAR-CP TexStar Cedar Park 06/30/2024 06/30/2024 32,802.57 32,802.57 0.00 32,802.57 5.31 1 1.00 32,802.57 0.00 32,802.57 0.03 NA MONEY MARKET FUNDS TOTAL 32,802.57 32,802.57 0.00 32,802.57 5.31 1 1.00 32,802.57 0.00 32,802.57 0.03 NA CONSTRUCTION FUNDS-2018 SWIFT TOTAL 32,802.57 32,802.57 0.00 32,802.57 5.31 1 1.00 32,802.57 0.00 32,802.57 0.03 NA CONSTRUCTION FUNDS-2022 SWIFT BANK DEPOSITS 1550578932LN Wells Fargo Analyzed Busi- ness Checking Plus PF - L 06/30/2024 06/30/2024 1,212.47 1,212.47 0.00 1,212.47 1.09 1 1.00 1,212.47 0.00 1,212.47 0.00 NA BANK DEPOSITS TOTAL 1,212.47 1,212.47 0.00 1,212.47 1.09 1 1.00 1,212.47 0.00 1,212.47 0.00 NA MONEY MARKET FUNDS TEXSTAR-LD TexStar Leander 06/30/2024 06/30/2024 36,146,951.92 36,146,951.92 0.00 36,146,951.92 5.31 1 1.00 36,146,951.92 0.00 36,146,951.92 31.66 NA MONEY MARKET FUNDS TOTAL 36,146,951.92 36,146,951.92 0.00 36,146,951.92 5.31 1 1.00 36,146,951.92 0.00 36,146,951.92 31.66 NA CONSTRUCTION FUNDS-2022 SWIFT TOTAL 36,148,164.39 36,148,164.39 0.00 36,148,164.39 5.31 1 1.00 36,148,164.39 0.00 36,148,164.39 31.66 NA ESCROW FUNDS 2018 BANK DEPOSITS 262006307CP Dreyfus Govt Cash Mgt Inst - Cedar Park 06/30/2024 06/30/2024 525.81 525.81 0.00 525.81 0.00 1 1.00 525.81 0.00 525.81 0.00 NA BANK DEPOSITS TOTAL 525.81 525.81 0.00 525.81 0.00 1 1.00 525.81 0.00 525.81 0.00 NA BRUSHY CREEK RUA | JUNE 30, 2024 17 Position Statement CUSIP DESCRIPTION TRADE DATE SETTLE DATE PAR VALUE PRINCIPAL COST PURCHASED INTEREST TOTAL COST YIELD MATURITY DATE DAYS TO MATURITY MARKET PRICE MARKET VALUE UNREALIZED GAIN/LOSS BOOK VALUE % OF MV MOODY'S S&P RATING MONEY MARKET FUNDS TEXSTAR-CP TexStar Cedar Park 06/30/2024 06/30/2024 170,088.53 170,088.53 0.00 170,088.53 5.31 1 1.00 170,088.53 0.00 170,088.53 0.15 NA MONEY MARKET FUNDS TOTAL 170,088.53 170,088.53 0.00 170,088.53 5.31 1 1.00 170,088.53 0.00 170,088.53 0.15 NA ESCROW FUNDS 2018 TOTAL 170,614.34 170,614.34 0.00 170,614.34 5.30 1 1.00 170,614.34 0.00 170,614.34 0.15 NA ESCROW FUNDS 2021 - CEDAR PARK MONEY MARKET FUNDS X9USDDGCM DREYFUS GVT CM;INST 06/30/2024 06/30/2024 7,016,579.39 7,016,579.39 0.00 7,016,579.39 5.19 1 1.00 7,016,579.39 0.00 7,016,579.39 6.15 Aaa AAA MONEY MARKET FUNDS TOTAL 7,016,579.39 7,016,579.39 0.00 7,016,579.39 5.19 1 1.00 7,016,579.39 0.00 7,016,579.39 6.15 Aaa AAA U.S. AGENCIES 3130AYKN5 FHLBANKS 4.810 01/10/25 01/29/2024 01/31/2024 7,500,000.00 7,499,062.50 13,027.08 7,512,089.58 4.82 01/10/2025 194 99.65 7,473,975.00 (25,500.54) 7,499,475.54 6.55 P-1 A-1+ U.S. AGENCIES TOTAL 7,500,000.00 7,499,062.50 13,027.08 7,512,089.58 4.82 194 99.65 7,473,975.00 (25,500.54) 7,499,475.54 6.55 P-1 A-1+ ESCROW FUNDS 2021 - CEDAR PARK TOTAL 14,516,579.39 14,515,641.89 13,027.08 14,528,668.97 5.00 101 51.88 14,490,554.39 (25,500.54) 14,516,054.93 12.69 AAA ESCROW FUNDS 2021 - LEANDER BANK DEPOSITS CCYUSD Cash 06/30/2024 06/30/2024 6.76 6.76 0.00 6.76 0.00 1 1.00 6.76 0.00 6.76 0.00 Aaa AAA BANK DEPOSITS TOTAL 6.76 6.76 0.00 6.76 0.00 1 1.00 6.76 0.00 6.76 0.00 Aaa AAA ESCROW FUNDS 2021 - LEANDER TOTAL 6.76 6.76 0.00 6.76 0.00 1 1.00 6.76 0.00 6.76 0.00 Aaa AAA OPERATING FUNDS BANK DEPOSITS 2550665125 Wells Fargo Analyzed Busi- ness Checking Plus PF 06/30/2024 06/30/2024 711,351.24 711,351.24 0.00 711,351.24 1.09 1 1.00 711,351.24 0.00 711,351.24 0.62 NA BRUSHY CREEK RUA | JUNE 30, 2024 18 Position Statement CUSIP DESCRIPTION TRADE DATE SETTLE DATE PAR VALUE PRINCIPAL COST PURCHASED INTEREST TOTAL COST YIELD MATURITY DATE DAYS TO MATURITY MARKET PRICE MARKET VALUE UNREALIZED GAIN/LOSS BOOK VALUE % OF MV MOODY'S S&P RATING BANK DEPOSITS TOTAL 711,351.24 711,351.24 0.00 711,351.24 1.09 1 1.00 711,351.24 0.00 711,351.24 0.62 NA MONEY MARKET FUNDS TEXSTAR-MO TexStar Master Operating 06/30/2024 06/30/2024 3,065,873.57 3,065,873.57 0.00 3,065,873.57 5.31 1 1.00 3,065,873.57 0.00 3,065,873.57 2.69 NA MONEY MARKET FUNDS TOTAL 3,065,873.57 3,065,873.57 0.00 3,065,873.57 5.31 1 1.00 3,065,873.57 0.00 3,065,873.57 2.69 NA OPERATING FUNDS TOTAL 3,777,224.81 3,777,224.81 0.00 3,777,224.81 4.52 1 1.00 3,777,224.81 0.00 3,777,224.81 3.31 NA ROUND ROCK ESFD23B BANK DEPOSITS CCYUSD Cash 06/30/2024 06/30/2024 100.00 100.00 0.00 100.00 0.00 1 1.00 100.00 0.00 100.00 0.00 Aaa AAA BANK DEPOSITS TOTAL 100.00 100.00 0.00 100.00 0.00 1 1.00 100.00 0.00 100.00 0.00 Aaa AAA ROUND ROCK ESFD23B TOTAL 100.00 100.00 0.00 100.00 0.00 1 1.00 100.00 0.00 100.00 0.00 Aaa AAA GRAND TOTAL 114,397,069.58 113,590,932.08 13,027.08 113,603,959.16 5.29 26 27.91 114,164,798.47 (25,500.54) 114,190,299.01 100.00 AA+ BRUSHY CREEK RUA | JUNE 30, 2024 19 Cash Reconciliation Report CONSTRUCTION FUNDS 2021 - CEDAR PARK POST DATE IDENTIFIER DESCRIPTION PAR VALUE FINAL MATURITY PRINCIPAL AMOUNT BUY 05/16/2024 62479LLF0 MUFG BANK NY 11/15/24 5,000,000.00 11/15/2024 4,864,783.33 -4,864,783.33 BUY TOTAL 5,000,000.00 4,864,783.33 -4,864,783.33 POST DATE IDENTIFIER DESCRIPTION PAR VALUE FINAL MATURITY PRINCIPAL AMOUNT MATURITY 05/14/2024 62479LEE1 MUFG Bank, Ltd., New York Branch 0.0 05/14/2024 -5,000,000.00 05/14/2024 -5,000,000.00 5,000,000.00 MATURITY TOTAL -5,000,000.00 -5,000,000.00 5,000,000.00 CONSTRUCTION FUNDS-2022 SWIFT POST DATE IDENTIFIER DESCRIPTION PAR VALUE FINAL MATURITY PRINCIPAL AMOUNT COUPON 06/14/2024 3130ATVC8 FEDERAL HOME LOAN BANKS 4.875 06/14/2024 0.00 06/14/2024 0.00 243,750.00 COUPON TOTAL 0.00 0.00 243,750.00 POST DATE IDENTIFIER DESCRIPTION PAR VALUE FINAL MATURITY PRINCIPAL AMOUNT MATURITY 06/14/2024 3130ATVC8 FEDERAL HOME LOAN BANKS 4.875 06/14/2024 -10,000,000.00 06/14/2024 -10,000,000.00 10,000,000.00 MATURITY TOTAL -10,000,000.00 -10,000,000.00 10,000,000.00 BRUSHY CREEK RUA | JUNE 30, 2024 20 Transaction Statement CONSTRUCTION FUNDS 2021 - CEDAR PARK TRADE DATE SETTLE DATE CUSIP DESCRIPTION PAR VALUE PRINCIPAL COST PURCHASED INTEREST TOTAL PURCHASE YIELD BUY 05/15/2024 05/16/2024 62479LLF0 MUFG BANK NY 11/15/24 5,000,000.00 4,864,783.33 0.00 (4,864,783.33)5.47 BUY TOTAL 5,000,000.00 4,864,783.33 0.00 (4,864,783.33)5.47 TRADE DATE SETTLE DATE CUSIP DESCRIPTION PAR VALUE BOOK VALUE TOTAL NET REALIZED GAIN/LOSS MATURITY 05/14/2024 05/14/2024 62479LEE1 MUFG Bank, Ltd., New York Branch 0.0 05/14/2024 (5,000,000.00)5,000,000.00 5,000,000.00 0.00 MATURITY TOTAL (5,000,000.00)5,000,000.00 5,000,000.00 0.00 CONSTRUCTION FUNDS-2022 SWIFT TRADE DATE SETTLE DATE CUSIP DESCRIPTION PAR VALUE BOOK VALUE TOTAL NET REALIZED GAIN/LOSS MATURITY 06/14/2024 06/14/2024 3130ATVC8 FEDERAL HOME LOAN BANKS 4.875 06/14/2024 (10,000,000.00)10,000,000.00 10,000,000.00 0.00 MATURITY TOTAL (10,000,000.00)10,000,000.00 10,000,000.00 0.00 BRUSHY CREEK RUA | JUNE 30, 2024 21 Amortization Schedule CUSIP DESCRIPTION PAR VALUE PRINCIPAL COST ORIGINAL PREMIUM OR DISCOUNT BEGINNING BOOK VALUE CURRENT PERIOD AMORT ENDING BOOK VALUE TOTAL AMORTIZATION UNAMORTIZED BALANCE 55607KH17 MACQUARIE BNK 08/01/24 7,500,000.00 7,301,750.00 (198,250.00)7,367,833.33 98,583.33 7,466,416.67 164,666.67 (33,583.33) 62479LLF0 MUFG BANK NY 11/15/24 5,000,000.00 4,864,783.33 (135,216.67)0.00 33,988.89 4,898,772.22 33,988.89 (101,227.78) 62479LEE1 MUFG Bank, Ltd., New York Branch 0.0 05/14/2024 5,000,000.00 4,860,250.00 (139,750.00)4,966,615.28 33,384.72 0.00 139,750.00 0.00 78015CHC9 ROYAL BK CA NYBR 08/12/24 6,500,000.00 6,233,337.50 (266,662.50)6,368,644.03 89,875.14 6,458,519.17 225,181.67 (41,480.83) 89233GH90 TOYOTA MOTOR CRD 08/09/24 5,000,000.00 4,794,929.17 (205,070.83)4,900,152.78 69,893.05 4,970,045.83 175,116.66 (29,954.17) TOTAL 29,000,000.00 28,055,050.00 (944,950.00)23,603,245.42 325,725.14 23,793,753.89 738,703.89 (206,246.11) 3130ATVC8 FEDERAL HOME LOAN BANKS 4.875 06/14/2024 10,000,000.00 10,023,080.00 23,080.00 10,003,415.42 (3,415.42)0.00 (23,080.00)0.00 TOTAL 10,000,000.00 10,023,080.00 0.00 10,003,415.42 (3,415.42)0.00 (23,080.00)0.00 ESCROW FUNDS 2021 - CEDAR PARK 3130AYKN5 FHLBANKS 4.810 01/10/25 7,500,000.00 7,499,062.50 (937.50)7,499,228.26 247.28 7,499,475.54 413.04 (524.46) TOTAL 7,500,000.00 7,499,062.50 (937.50)7,499,228.26 247.28 7,499,475.54 413.04 (524.46) GRAND TOTAL 46,500,000.00 45,577,192.50 (945,887.50)41,105,889.10 322,557.00 31,293,229.43 716,036.93 (206,770.57) BRUSHY CREEK RUA | JUNE 30, 2024 22 Accrued Interest Schedule IDENTIFIER DESCRIPTION SETTLE DATE PAR VALUE PRINCIPAL COST BEGINNING ACCRUED INTEREST PURCHASED INTEREST CURRENT PERIOD ACCRUAL INTEREST RECEIVED ENDING ACCRUED INTEREST CEDAR PARK-ESFD23B CCYUSD Cash 2024-06-30 100.00 100.00 0.00 0.00 0.00 0.00 0.00 TOTAL 100.00 100.00 0.00 0.00 0.00 0.00 0.00 CONSTRUCTION FUNDS TEXSTAR-MC TexStar Master Construction 2024-06-30 2,492,372.12 2,492,372.12 0.00 0.00 26,904.93 26,904.93 0.00 TOTAL 2,492,372.12 2,492,372.12 0.00 0.00 26,904.93 26,904.93 0.00 CONSTRUCTION FUNDS 2021 - CEDAR PARK 55607KH17 MACQUARIE BNK 08/01/24 2024-01-31 7,500,000.00 7,301,750.00 0.00 0.00 0.00 0.00 0.00 62479LLF0 MUFG BANK NY 11/15/24 2024-05-16 5,000,000.00 4,864,783.33 0.00 0.00 0.00 0.00 0.00 78015CHC9 ROYAL BK CA NYBR 08/12/24 2023-11-16 6,500,000.00 6,233,337.50 0.00 0.00 0.00 0.00 0.00 89233GH90 TOYOTA MOTOR CRD 08/09/24 2023-11-16 5,000,000.00 4,794,929.17 0.00 0.00 0.00 0.00 0.00 TEXSTAR-CP TexStar Cedar Park 2024-06-30 9,992,732.60 9,992,732.60 0.00 0.00 92,305.70 92,305.70 0.00 1550578940CP Wells Fargo Analyzed Business Checking Plus PF - C 2024-06-30 300.53 300.53 0.00 0.00 300.53 300.53 0.00 TOTAL 33,993,033.13 33,187,833.13 0.00 0.00 92,606.23 92,606.23 0.00 CONSTRUCTION FUNDS 2021 - LEANDER TEXSTAR-LD TexStar Leander 2024-06-30 0.00 0.00 0.00 0.00 2,865.79 2,865.79 0.00 TOTAL 0.00 0.00 0.00 0.00 2,865.79 2,865.79 0.00 CONSTRUCTION FUNDS 2023 - CEDAR PARK TEXSTAR-CP TexStar Cedar Park 2024-06-30 7,206,738.85 7,206,738.85 0.00 0.00 65,906.13 65,906.13 0.00 TOTAL 7,206,738.85 7,206,738.85 0.00 0.00 65,906.13 65,906.13 0.00 CONSTRUCTION FUNDS 2023 - ROUND ROCK TEXSTAR-RR TexStar Round Rock 2024-06-30 14,983,966.55 14,983,966.55 0.00 0.00 137,736.01 137,736.01 0.00 TOTAL 14,983,966.55 14,983,966.55 0.00 0.00 137,736.01 137,736.01 0.00 BRUSHY CREEK RUA | JUNE 30, 2024 23 Accrued Interest Schedule IDENTIFIER DESCRIPTION SETTLE DATE PAR VALUE PRINCIPAL COST BEGINNING ACCRUED INTEREST PURCHASED INTEREST CURRENT PERIOD ACCRUAL INTEREST RECEIVED ENDING ACCRUED INTEREST CONSTRUCTION FUNDS LEANDER 2009 TEXSTAR-LD TexStar Leander 2024-06-30 1,075,366.67 1,075,366.67 0.00 0.00 17,791.50 17,791.50 0.00 TOTAL 1,075,366.67 1,075,366.67 0.00 0.00 17,791.50 17,791.50 0.00 CONSTRUCTION FUNDS-2018 SWIFT TEXSTAR-CP TexStar Cedar Park 2024-06-30 32,802.57 32,802.57 0.00 0.00 582.06 582.06 0.00 TOTAL 32,802.57 32,802.57 0.00 0.00 582.06 582.06 0.00 CONSTRUCTION FUNDS-2022 SWIFT 3130ATVC8 FEDERAL HOME LOAN BANKS 4.875 06/14/2024 2023-01-30 0.00 0.00 144,895.83 0.00 98,854.17 243,750.00 0.00 TEXSTAR-LD TexStar Leander 2024-06-30 36,146,951.92 36,146,951.92 0.00 0.00 251,086.51 251,086.51 0.00 1550578932LN Wells Fargo Analyzed Business Checking Plus PF - L 2024-06-30 1,212.47 1,212.47 0.00 0.00 1,212.47 1,212.47 0.00 TOTAL 36,148,164.39 36,148,164.39 144,895.83 0.00 351,153.15 496,048.98 0.00 ESCROW FUNDS 2018 262006307CP Dreyfus Govt Cash Mgt Inst - Cedar Park 2024-06-30 525.81 525.81 0.00 0.00 4.27 4.27 0.00 TEXSTAR-CP TexStar Cedar Park 2024-06-30 170,088.53 170,088.53 0.00 0.00 1,499.27 1,499.27 0.00 TOTAL 170,614.34 170,614.34 0.00 0.00 1,503.54 1,503.54 0.00 ESCROW FUNDS 2021 - CEDAR PARK X9USDDGCM DREYFUS GVT CM;INST 2024-06-30 7,016,579.39 7,016,579.39 0.00 0.00 120,748.51 90,863.43 0.00 3130AYKN5 FHLBANKS 4.810 01/10/25 2024-01-31 7,500,000.00 7,499,062.50 73,152.08 13,027.08 90,187.50 0.00 163,339.58 TOTAL 14,516,579.39 14,515,641.89 73,152.08 13,027.08 210,936.01 90,863.43 163,339.58 ESCROW FUNDS 2021 - LEANDER CCYUSD Cash 2024-06-30 6.76 6.76 0.00 0.00 0.00 0.00 0.00 BRUSHY CREEK RUA | JUNE 30, 2024 24 Accrued Interest Schedule IDENTIFIER DESCRIPTION SETTLE DATE PAR VALUE PRINCIPAL COST BEGINNING ACCRUED INTEREST PURCHASED INTEREST CURRENT PERIOD ACCRUAL INTEREST RECEIVED ENDING ACCRUED INTEREST X9USDDGCM DREYFUS GVT CM;INST 2024-06-30 0.00 0.00 0.00 0.00 14.24 14.24 0.00 TOTAL 6.76 6.76 0.00 0.00 14.24 14.24 0.00 OPERATING FUNDS TEXSTAR TexSTAR 2024-06-30 0.00 0.00 0.00 0.00 13,337.31 13,337.31 0.00 TEXSTAR-MO TexStar Master Operating 2024-06-30 3,065,873.57 3,065,873.57 0.00 0.00 29,617.05 29,617.05 0.00 2550665125 Wells Fargo Analyzed Business Checking Plus PF 2024-06-30 711,351.24 711,351.24 0.00 0.00 1,966.46 1,966.46 0.00 TOTAL 3,777,224.81 3,777,224.81 0.00 0.00 44,920.82 44,920.82 0.00 ROUND ROCK ESFD23B CCYUSD Cash 2024-06-30 100.00 100.00 0.00 0.00 0.00 0.00 0.00 TOTAL 100.00 100.00 0.00 0.00 0.00 0.00 0.00 GRAND TOTAL 114,397,069.58 113,590,932.08 218,047.92 13,027.08 952,920.41 977,743.66 163,339.58 BRUSHY CREEK RUA | JUNE 30, 2024 25 Earnings by Fund CUSIP DESCRIPTION ENDING PAR VALUE BEGINNING BOOK VALUE ENDING BOOK VALUE FINAL MATURITY COUPON RATE YIELD INTEREST EARNED NET AMORTIZATION/ ACCRETION INCOME NET REALIZED GAIN/LOSS ADJUSTED INTEREST EARNINGS CEDAR PARK-ESFD23 CCYUSD Cash 0.00 78,572.08 0.00 06/30/2024 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL 0.00 78,572.08 0.00 0.00 0.00 0.00 0.00 0.00 0.00 CEDAR PARK-ESFD23B CCYUSD Cash 100.00 100.00 100.00 06/30/2024 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL 100.00 100.00 100.00 0.00 0.00 0.00 0.00 0.00 0.00 CONSTRUCTION FUNDS TEXSTAR-MC TexStar Master Construction 2,492,372.12 3,190,003.29 2,492,372.12 06/30/2024 0.00 5.31 26,904.93 0.00 0.00 26,904.93 TOTAL 2,492,372.12 3,190,003.29 2,492,372.12 0.00 5.31 26,904.93 0.00 0.00 26,904.93 CONSTRUCTION FUNDS 2021 - CEDAR PARK 1550578940CP Wells Fargo Analyzed Business Checking Plus PF - C 300.53 740.45 300.53 06/30/2024 0.00 1.06 300.53 0.00 0.00 300.53 55607KH17 MACQUARIE BNK 08/01/24 7,500,000.00 7,367,833.33 7,466,416.67 08/01/2024 0.00 5.34 0.00 98,583.33 0.00 98,583.33 62479LEE1 MUFG Bank, Ltd., New York Branch 0.0 05/14/2024 0.00 4,966,615.28 0.00 05/14/2024 0.00 5.75 0.00 33,384.72 0.00 33,384.72 62479LLF0 MUFG BANK NY 11/15/24 5,000,000.00 0.00 4,898,772.22 11/15/2024 0.00 5.47 0.00 33,988.89 0.00 33,988.89 78015CHC9 ROYAL BK CA NYBR 08/12/24 6,500,000.00 6,368,644.03 6,458,519.17 08/12/2024 0.00 5.66 0.00 89,875.14 0.00 89,875.14 89233GH90 TOYOTA MOTOR CRD 08/09/24 5,000,000.00 4,900,152.78 4,970,045.83 08/09/2024 0.00 5.73 0.00 69,893.05 0.00 69,893.05 TEXSTAR-CP TexStar Cedar Park 9,992,732.60 10,651,328.23 9,992,732.60 06/30/2024 0.00 5.31 92,305.70 0.00 0.00 92,305.70 TOTAL 33,993,033.13 34,255,314.10 33,786,787.02 0.00 5.47 92,606.23 325,725.14 0.00 418,331.37 CONSTRUCTION FUNDS 2021 - LEANDER TEXSTAR-LD TexStar Leander 0.00 1,186,769.01 0.00 06/30/2024 0.00 5.31 2,865.79 0.00 0.00 2,865.79 TOTAL 0.00 1,186,769.01 0.00 0.00 5.31 2,865.79 0.00 0.00 2,865.79 CONSTRUCTION FUNDS 2023 - CEDAR PARK BRUSHY CREEK RUA | JUNE 30, 2024 26 Earnings by Fund CUSIP DESCRIPTION ENDING PAR VALUE BEGINNING BOOK VALUE ENDING BOOK VALUE FINAL MATURITY COUPON RATE YIELD INTEREST EARNED NET AMORTIZATION/ ACCRETION INCOME NET REALIZED GAIN/LOSS ADJUSTED INTEREST EARNINGS TEXSTAR-CP TexStar Cedar Park 7,206,738.85 7,578,003.97 7,206,738.85 06/30/2024 0.00 5.31 65,906.13 0.00 0.00 65,906.13 TOTAL 7,206,738.85 7,578,003.97 7,206,738.85 0.00 5.31 65,906.13 0.00 0.00 65,906.13 CONSTRUCTION FUNDS 2023 - ROUND ROCK TEXSTAR-RR TexStar Round Rock 14,983,966.55 15,583,406.50 14,983,966.55 06/30/2024 0.00 5.31 137,736.01 0.00 0.00 137,736.01 TOTAL 14,983,966.55 15,583,406.50 14,983,966.55 0.00 5.31 137,736.01 0.00 0.00 137,736.01 CONSTRUCTION FUNDS LEANDER 2009 TEXSTAR-LD TexStar Leander 1,075,366.67 2,802,718.09 1,075,366.67 06/30/2024 0.00 5.31 17,791.50 0.00 0.00 17,791.50 TOTAL 1,075,366.67 2,802,718.09 1,075,366.67 0.00 5.31 17,791.50 0.00 0.00 17,791.50 CONSTRUCTION FUNDS-2018 SWIFT TEXSTAR-CP TexStar Cedar Park 32,802.57 93,287.31 32,802.57 06/30/2024 0.00 5.31 582.06 0.00 0.00 582.06 TOTAL 32,802.57 93,287.31 32,802.57 0.00 5.31 582.06 0.00 0.00 582.06 CONSTRUCTION FUNDS-2022 SWIFT 1550578932LN Wells Fargo Analyzed Business Checking Plus PF - L 1,212.47 0.02 1,212.47 06/30/2024 0.00 1.09 1,212.47 0.00 0.00 1,212.47 3130ATVC8 FEDERAL HOME LOAN BANKS 4.875 06/14/2024 0.00 10,003,415.42 0.00 06/14/2024 4.88 4.69 98,854.17 (3,415.42)0.00 95,438.74 TEXSTAR-LD TexStar Leander 36,146,951.92 25,960,470.75 36,146,951.92 06/30/2024 0.00 5.31 251,086.51 0.00 0.00 251,086.51 TOTAL 36,148,164.39 35,963,886.19 36,148,164.39 0.00 5.31 351,153.15 (3,415.42)0.00 347,737.72 ESCROW FUNDS 2018 262006307CP Dreyfus Govt Cash Mgt Inst - Cedar Park 525.81 519.37 525.81 06/30/2024 0.00 0.00 4.27 0.00 0.00 4.27 TEXSTAR-CP TexStar Cedar Park 170,088.53 167,857.23 170,088.53 06/30/2024 0.00 5.31 1,499.27 0.00 0.00 1,499.27 TOTAL 170,614.34 168,376.60 170,614.34 0.00 5.30 1,503.54 0.00 0.00 1,503.54 BRUSHY CREEK RUA | JUNE 30, 2024 27 Earnings by Fund CUSIP DESCRIPTION ENDING PAR VALUE BEGINNING BOOK VALUE ENDING BOOK VALUE FINAL MATURITY COUPON RATE YIELD INTEREST EARNED NET AMORTIZATION/ ACCRETION INCOME NET REALIZED GAIN/LOSS ADJUSTED INTEREST EARNINGS ESCROW FUNDS 2021 - CEDAR PARK 3130AYKN5 FHLBANKS 4.810 01/10/25 7,500,000.00 7,499,228.26 7,499,475.54 01/10/2025 4.81 4.82 90,187.50 247.28 0.00 90,434.78 X9USDDGCM DREYFUS GVT CM;INST 7,016,579.39 6,925,715.96 7,016,579.39 06/30/2024 5.17 5.19 120,748.51 0.00 0.00 120,748.51 TOTAL 14,516,579.39 14,424,944.22 14,516,054.93 4.98 5.00 210,936.01 247.28 0.00 211,183.29 ESCROW FUNDS 2021 - LEANDER CCYUSD Cash 6.76 0.00 6.76 06/30/2024 0.00 0.00 0.00 0.00 0.00 0.00 X9USDDGCM DREYFUS GVT CM;INST 0.00 1,705.63 0.00 06/30/2024 5.17 5.19 14.24 0.00 0.00 14.24 TOTAL 6.76 1,705.63 6.76 0.00 0.00 14.24 0.00 0.00 14.24 OPERATING FUNDS 2550665125 Wells Fargo Analyzed Business Checking Plus PF 711,351.24 700,800.14 711,351.24 06/30/2024 0.00 1.09 1,966.46 0.00 0.00 1,966.46 TEXSTAR TexSTAR 0.00 0.00 0.00 06/30/2024 5.30 5.31 13,337.31 0.00 0.00 13,337.31 TEXSTAR-MC TexStar Master Construction 0.00 2,707,281.42 0.00 06/30/2024 0.00 0.00 0.00 0.00 0.00 0.00 TEXSTAR-MO TexStar Master Operating 3,065,873.57 0.00 3,065,873.57 06/30/2024 0.00 5.31 29,617.05 0.00 0.00 29,617.05 TOTAL 3,777,224.81 3,408,081.56 3,777,224.81 0.00 4.52 44,920.82 0.00 0.00 44,920.82 ROUND ROCK ESFD23B CCYUSD Cash 100.00 100.00 100.00 06/30/2024 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL 100.00 100.00 100.00 0.00 0.00 0.00 0.00 0.00 0.00 ROUND ROCK-ESFD23 CCYUSD Cash 0.00 369,276.72 0.00 06/30/2024 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL 0.00 369,276.72 0.00 0.00 0.00 0.00 0.00 0.00 0.00 GRAND TOTAL 114,397,069.58 119,104,545.27 114,190,299.01 0.64 5.29 952,920.41 322,557.00 0.00 1,275,477.41 BRUSHY CREEK RUA | JUNE 30, 2024 28 CUSIP DESCRIPTION POST DATE TRANSACTION TYPE AMOUNT CONSTRUCTION FUNDS 2021 - CEDAR PARK AUG 2024 55607KH17 MACQUARIE BNK 08/01/24 08/01/2024 Final Maturity 7,500,000.00 89233GH90 TOYOTA MOTOR CRD 08/09/24 08/09/2024 Final Maturity 5,000,000.00 78015CHC9 ROYAL BK CA NYBR 08/12/24 08/12/2024 Final Maturity 6,500,000.00 AUG 2024 TOTAL 19,000,000.00 NOV 2024 62479LLF0 MUFG BANK NY 11/15/24 11/15/2024 Final Maturity 5,000,000.00 NOV 2024 TOTAL 5,000,000.00 CONSTRUCTION FUNDS 2021 - CEDAR PARK TOTAL 24,000,000.00 ESCROW FUNDS 2021 - CEDAR PARK JUL 2024 3130AYKN5 FHLBANKS 4.810 01/10/25 07/10/2024 Coupon 172,358.33 JUL 2024 TOTAL 172,358.33 ESCROW FUNDS 2021 - CEDAR PARK TOTAL 172,358.33 GRAND TOTAL 24,172,358.33 Projected Cashflows For the Period July 01, 2024 to December 31, 2024 BRUSHY CREEK RUA | JUNE 30, 2024 29 Change in Value IDENTIFIER ISSUER PAR VALUE YIELD TRADE DATE MATURITY DATE INTEREST ACCRUAL INTEREST RECEIVED BEGINNING BOOK VALUE BEGINNING MARKET VALUE PURCHASES/ ADDITIONS REDEMPTIONS CHANGE IN BOOK VALUE CHANGE IN MARKET VALUE ENDING BOOK VALUE ENDING MARKET VALUE CEDAR PARK-ESFD23 CCYUSD Cash 0.00 0.00 06/30/2024 0.00 0.00 78,572.08 78,572.08 0.00 0.00 (78,572.08) (78,572.08) 0.00 0.00 TOTAL 0.00 0.00 0.00 78,572.08 78,572.08 0.00 0.00 (78,572.08) (78,572.08) 0.00 0.00 CEDAR PARK-ESFD23B CCYUSD Cash 100.00 0.00 06/30/2024 0.00 0.00 100.00 100.00 0.00 0.00 0.00 0.00 100.00 100.00 TOTAL 0.00 0.00 0.00 100.00 100.00 0.00 0.00 0.00 0.00 100.00 100.00 CONSTRUCTION FUNDS TEXSTAR-MC TexStar Master Construction 2,492,372.12 5.31 06/30/2024 26,904.93 26,904.93 3,190,003.29 3,190,003.29 70,319.16 (767,950.33)(697,631.17) (697,631.17) 2,492,372.12 2,492,372.12 TEXSTAR-LD TexStar Leander 0.00 0.00 04/30/2024 06/30/2024 0.00 0.00 0.00 0.00 2,802,718.09 (2,802,718.09)0.00 0.00 0.00 0.00 TOTAL 5.31 26,904.93 26,904.93 3,190,003.29 3,190,003.29 2,873,037.25 (3,570,668.42)(697,631.17) (697,631.17) 2,492,372.12 2,492,372.12 CONSTRUCTION FUNDS 2021 - CEDAR PARK 62479LEE1 MUFG Bank, Ltd., New York Branch 0.0 05/14/2024 0.00 5.75 11/14/2023 05/14/2024 0.00 0.00 4,966,615.28 4,966,615.28 0.00 (5,000,000.00)(4,966,615.28) (4,966,615.28) 0.00 0.00 TEXSTAR-CP TexStar Cedar Park 9,992,732.60 5.31 06/30/2024 92,305.70 92,305.70 10,651,328.23 10,651,328.23 73,933.37 (732,529.00)(658,595.63) (658,595.63) 9,992,732.60 9,992,732.60 1550578940CP Wells Fargo Analyzed Business Checking Plus PF - C 300.53 1.06 06/30/2024 300.53 300.53 740.45 740.45 0.92 (440.84)(439.92) (439.92) 300.53 300.53 55607KH17 MACQUARIE BNK 08/01/24 7,500,000.00 5.34 01/25/2024 08/01/2024 0.00 0.00 7,367,833.33 7,367,833.33 0.00 0.00 98,583.33 98,583.33 7,466,416.67 7,466,416.67 89233GH90 TOYOTA MOTOR CRD 08/09/24 5,000,000.00 5.73 11/14/2023 08/09/2024 0.00 0.00 4,900,152.78 4,900,152.78 0.00 0.00 69,893.05 69,893.05 4,970,045.83 4,970,045.83 BRUSHY CREEK RUA | JUNE 30, 2024 30 Change in Value IDENTIFIER ISSUER PAR VALUE YIELD TRADE DATE MATURITY DATE INTEREST ACCRUAL INTEREST RECEIVED BEGINNING BOOK VALUE BEGINNING MARKET VALUE PURCHASES/ ADDITIONS REDEMPTIONS CHANGE IN BOOK VALUE CHANGE IN MARKET VALUE ENDING BOOK VALUE ENDING MARKET VALUE 78015CHC9 ROYAL BK CA NYBR 08/12/24 6,500,000.00 5.66 11/14/2023 08/12/2024 0.00 0.00 6,368,644.03 6,368,644.03 0.00 0.00 89,875.14 89,875.14 6,458,519.17 6,458,519.17 62479LLF0 MUFG BANK NY 11/15/24 5,000,000.00 5.47 05/15/2024 11/15/2024 0.00 0.00 0.00 0.00 4,864,783.33 0.00 4,898,772.22 4,898,772.22 4,898,772.22 4,898,772.22 TOTAL 5.47 92,606.23 92,606.23 34,255,314.10 34,255,314.10 4,938,717.62 (5,732,969.84)(468,527.08) (468,527.08) 33,786,787.02 33,786,787.02 CONSTRUCTION FUNDS 2021 - LEANDER TEXSTAR-LD TexStar Leander 0.00 5.31 01/31/2024 06/30/2024 2,865.79 2,865.79 1,186,769.01 1,186,769.01 0.00 (1,186,769.01)(1,186,769.01) (1,186,769.01) 0.00 0.00 TOTAL 5.31 2,865.79 2,865.79 1,186,769.01 1,186,769.01 0.00 (1,186,769.01)(1,186,769.01) (1,186,769.01) 0.00 0.00 CONSTRUCTION FUNDS 2023 - CEDAR PARK TEXSTAR-CP TexStar Cedar Park 7,206,738.85 5.31 06/30/2024 65,906.13 65,906.13 7,578,003.97 7,578,003.97 142,951.28 (514,216.40)(371,265.12) (371,265.12) 7,206,738.85 7,206,738.85 TOTAL 5.31 65,906.13 65,906.13 7,578,003.97 7,578,003.97 142,951.28 (514,216.40)(371,265.12) (371,265.12) 7,206,738.85 7,206,738.85 CONSTRUCTION FUNDS 2023 - ROUND ROCK TEXSTAR-RR TexStar Round Rock 14,983,966.55 5.31 06/30/2024 137,736.01 137,736.01 15,583,406.50 15,583,406.50 205,864.31 (805,304.26)(599,439.95) (599,439.95) 14,983,966.55 14,983,966.55 TOTAL 5.31 137,736.01 137,736.01 15,583,406.50 15,583,406.50 205,864.31 (805,304.26)(599,439.95) (599,439.95) 14,983,966.55 14,983,966.55 CONSTRUCTION FUNDS LEANDER 2009 TEXSTAR-LD TexStar Leander 1,075,366.67 5.31 06/30/2024 17,791.50 17,791.50 2,802,718.09 2,802,718.09 2,456,701.47 (4,184,052.89)(1,727,351.42) (1,727,351.42) 1,075,366.67 1,075,366.67 TOTAL 5.31 17,791.50 17,791.50 2,802,718.09 2,802,718.09 2,456,701.47 (4,184,052.89)(1,727,351.42) (1,727,351.42) 1,075,366.67 1,075,366.67 BRUSHY CREEK RUA | JUNE 30, 2024 31 Change in Value IDENTIFIER ISSUER PAR VALUE YIELD TRADE DATE MATURITY DATE INTEREST ACCRUAL INTEREST RECEIVED BEGINNING BOOK VALUE BEGINNING MARKET VALUE PURCHASES/ ADDITIONS REDEMPTIONS CHANGE IN BOOK VALUE CHANGE IN MARKET VALUE ENDING BOOK VALUE ENDING MARKET VALUE CONSTRUCTION FUNDS-2018 SWIFT TEXSTAR-CP TexStar Cedar Park 32,802.57 5.31 01/31/2024 06/30/2024 582.06 582.06 93,287.31 93,287.31 0.00 (60,484.74)(60,484.74) (60,484.74) 32,802.57 32,802.57 TOTAL 5.31 582.06 582.06 93,287.31 93,287.31 0.00 (60,484.74)(60,484.74) (60,484.74) 32,802.57 32,802.57 CONSTRUCTION FUNDS-2022 SWIFT 3130ATVC8 FEDERAL HOME LOAN BANKS 4.875 06/14/2024 0.00 4.69 01/26/2023 06/14/2024 98,854.17 243,750.00 10,003,415.42 9,987,400.00 0.00 (10,000,000.00)(10,003,415.42) (9,987,400.00) 0.00 0.00 TEXSTAR-LD TexStar Leander 36,146,951.92 5.31 06/30/2024 251,086.51 251,086.51 25,960,470.75 25,960,470.75 10,186,481.17 0.00 10,186,481.17 10,186,481.17 36,146,951.92 36,146,951.92 1550578932LN Wells Fargo Analyzed Business Checking Plus PF - L 1,212.47 1.09 06/30/2024 1,212.47 1,212.47 0.02 0.02 1,212.45 0.00 1,212.45 1,212.45 1,212.47 1,212.47 TOTAL 5.31 351,153.15 496,048.98 35,963,886.19 35,947,870.77 10,187,693.62 (10,000,000.00)184,278.20 200,293.62 36,148,164.39 36,148,164.39 ESCROW FUNDS 2018 TEXSTAR-CP TexStar Cedar Park 170,088.53 5.31 06/30/2024 1,499.27 1,499.27 167,857.23 167,857.23 2,231.30 0.00 2,231.30 2,231.30 170,088.53 170,088.53 262006307CP Dreyfus Govt Cash Mgt Inst - Cedar Park 525.81 0.00 06/30/2024 4.27 4.27 519.37 519.37 6.44 0.00 6.44 6.44 525.81 525.81 TOTAL 5.30 1,503.54 1,503.54 168,376.60 168,376.60 2,237.74 0.00 2,237.74 2,237.74 170,614.34 170,614.34 ESCROW FUNDS 2021 - CEDAR PARK X9USDDGCM DREYFUS GVT CM;INST 7,016,579.39 5.19 06/30/2024 120,748.51 90,863.43 6,925,715.96 6,925,715.96 90,863.43 0.00 90,863.43 90,863.43 7,016,579.39 7,016,579.39 3130AYKN5 FHLBANKS 4.810 01/10/25 7,500,000.00 4.82 01/29/2024 01/10/2025 90,187.50 0.00 7,499,228.26 7,470,450.00 0.00 0.00 247.28 3,525.00 7,499,475.54 7,473,975.00 TOTAL 5.00 210,936.01 90,863.43 14,424,944.22 14,396,165.96 90,863.43 0.00 91,110.71 94,388.43 14,516,054.93 14,490,554.39 BRUSHY CREEK RUA | JUNE 30, 2024 32 Change in Value IDENTIFIER ISSUER PAR VALUE YIELD TRADE DATE MATURITY DATE INTEREST ACCRUAL INTEREST RECEIVED BEGINNING BOOK VALUE BEGINNING MARKET VALUE PURCHASES/ ADDITIONS REDEMPTIONS CHANGE IN BOOK VALUE CHANGE IN MARKET VALUE ENDING BOOK VALUE ENDING MARKET VALUE ESCROW FUNDS 2021 - LEANDER CCYUSD Cash 6.76 0.00 06/30/2024 0.00 0.00 0.00 0.00 0.00 0.00 6.76 6.76 6.76 6.76 X9USDDGCM DREYFUS GVT CM;INST 0.00 5.19 06/30/2024 14.24 14.24 1,705.63 1,705.63 7.48 (1,713.11)(1,705.63) (1,705.63) 0.00 0.00 TOTAL 0.00 14.24 14.24 1,705.63 1,705.63 7.48 (1,713.11)(1,698.87) (1,698.87) 6.76 6.76 OPERATING FUNDS TEXSTAR-MO TexStar Master Operating 3,065,873.57 5.31 04/30/2024 06/30/2024 29,617.05 29,617.05 0.00 0.00 3,784,087.59 (718,214.02)3,065,873.57 3,065,873.57 3,065,873.57 3,065,873.57 TEXSTAR TexSTAR 0.00 5.31 04/30/2024 06/30/2024 13,337.31 13,337.31 0.00 0.00 3,784,087.59 (3,784,087.59)0.00 0.00 0.00 0.00 2550665125 Wells Fargo Analyzed Business Checking Plus PF 711,351.24 1.09 06/30/2024 1,966.46 1,966.46 700,800.14 700,800.14 700,763.09 (690,211.99)10,551.10 10,551.10 711,351.24 711,351.24 TEXSTAR-MC TexStar Master Construction 0.00 0.00 06/30/2024 0.00 0.00 2,707,281.42 2,707,281.42 1,076,806.17 (3,784,087.59)(2,707,281.42) (2,707,281.42) 0.00 0.00 TOTAL 4.52 44,920.82 44,920.82 3,408,081.56 3,408,081.56 9,345,744.44 (8,976,601.19)369,143.25 369,143.25 3,777,224.81 3,777,224.81 ROUND ROCK ESFD23B CCYUSD Cash 100.00 0.00 06/30/2024 0.00 0.00 100.00 100.00 0.00 0.00 0.00 0.00 100.00 100.00 TOTAL 0.00 0.00 0.00 100.00 100.00 0.00 0.00 0.00 0.00 100.00 100.00 ROUND ROCK-ESFD23 CCYUSD Cash 0.00 0.00 06/30/2024 0.00 0.00 369,276.72 369,276.72 0.00 0.00 (369,276.72) (369,276.72) 0.00 0.00 TOTAL 0.00 0.00 0.00 369,276.72 369,276.72 0.00 0.00 (369,276.72) (369,276.72) 0.00 0.00 BRUSHY CREEK RUA | JUNE 30, 2024 33 Change in Value IDENTIFIER ISSUER PAR VALUE YIELD TRADE DATE MATURITY DATE INTEREST ACCRUAL INTEREST RECEIVED BEGINNING BOOK VALUE BEGINNING MARKET VALUE PURCHASES/ ADDITIONS REDEMPTIONS CHANGE IN BOOK VALUE CHANGE IN MARKET VALUE ENDING BOOK VALUE ENDING MARKET VALUE GRAND TOTAL 5.29 952,920.41 977,743.66 119,104,545.27 119,059,751.59 30,243,818.64 (35,032,779.86)(4,914,246.26) (4,894,953.12) 114,190,299.01 114,164,798.47 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 has 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 Meeder. This information is provided as a client convenience and Meeder 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 provided by Meeder Public Funds, Inc. Please contact us if you would like to receive a copy of our current ADV disclosure brochure or privacy policy. © 2024 Meeder Investment Management meederpublicfunds.com | 866.633.3371 Disclosure