Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
BCRUA-2024-014 - 7/24/2024
RESOLUTION NO. BCRUA-2024-Ql I 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, 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 24th day of July, 2024. NA'COLE THOMPSO , President Brushy Creek Regional Utility Authority ATTE..T: RENE fLORES, Secretar ❑310.4614 A.4H.l1 2411 4Y14 Quarterly Investment Report BRUSHY CREEK RUA AS OF MARCH 31, 2024 EXHIBIT "A" BRUSHY CREEK RUA | MARCH 31, 2024 Compliance Certification The undersigned acknowledge they have reviewed this quarterly investment report for the period ending March 31, 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 | MARCH 31, 2024 3 Contents Portfolio Statistics 4 Quarterly Portfolio Summary 5 Quarterly Portfolio Summary By Fund 6 Portfolio Overview 7 Summary by Type 8 Position Statement 11 Cash Reconciliation Report 16 Transaction Statement 18 Amortization Schedule 20 Accrued Interest Schedule 21 Earnings by Fund 24 Projected Cashflows 27 Change in Value 28 4 Portfolio Statistics Par Value $119,498,656 Principal Cost $118,711,065 Book Value $119,104,545 Market Value $119,059,752 Unrealized Gain/Loss ($44,794) Accrued Interest $218,048 Portfolio Position Sector AllocationMaturity Distribution • 1 Money Market Funds 64.55%• 1 Commercial Paper 19.82%• 1 U.S. Agencies 14.66%• 1 Bank Deposits 0.97% 4.36 Average Yield 0.13 Weighted Average Maturity (Years) 0.15 Portfolio Effective Duration (Years) 0.13 Weighted Average Life (Years) AA Average Credit Rating BRUSHY CREEK RUA MARCH 31, 2024 BRUSHY CREEK RUA | MARCH 31, 2024 5 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 March 31, 2024 BEGINNING BOOK VALUE $150,010,357.64 BEGINNING MARKET VALUE $149,936,166.62 UNREALIZED GAIN/(LOSS)($74,191.00) WEIGHTED AVERAGE MATURITY (YEARS)0.27 WEIGHTED AVERAGE YIELD 4.83 ENDING BOOK VALUE $119,104,545.27 ENDING MARKET VALUE $119,059,751.59 INVESTMENT INCOME FOR THE PERIOD $1,350,522.74 UNREALIZED GAIN/(LOSS)($44,793.68) CHANGE IN UNREALIZED GAIN/(LOSS)$56,005.79 WEIGHTED AVERAGE MATURITY (YEARS)0.13 WEIGHTED AVERAGE YIELD 4.36 Portfolio as of December 31, 2023 BRUSHY CREEK RUA | MARCH 31, 2024 6 PORTFOLIO MARKET VALUE BY FUND 12/31/2023 03/31/2024 CHANGE INTEREST EARNED CEDAR PARK-ESFD23 7,526,481.89 78,572.08 -7,447,909.81 11,802.89 CEDAR PARK-ESFD23B 0.00 100.00 100.00 0.00 CONSTRUCTION FUNDS 8,051,724.50 3,190,003.29 -4,861,721.21 41,192.31 CONSTRUCTION FUNDS 2021 37,723,062.51 35,442,083.11 -2,280,979.40 365,135.85 CONSTRUCTION FUNDS 2023 0.00 23,161,410.47 23,161,410.47 196,141.44 CONSTRUCTION FUNDS LEANDER 2009 0.00 2,802,718.09 2,802,718.09 0.00 CONSTRUCTION FUNDS-2018 SWIFT 140,457.54 93,287.31 -47,170.23 138,328.09 CONSTRUCTION FUNDS-2022 SWIFT 35,386,256.60 35,947,870.77 561,614.17 437,460.37 ESCROW FUNDS 2018 166,152.86 168,376.60 2,223.74 6,995.54 ESCROW FUNDS 2021 16,501,556.04 14,397,871.59 -2,103,684.51 112,198.04 OPERATING FUNDS 2,823,693.57 3,408,081.56 584,387.99 41,268.21 ROUND ROCK ESFD23B 0.00 100.00 100.00 0.00 ROUND ROCK-ESFD23 41,616,781.11 369,276.72 -41,247,504.39 0.00 TOTAL 149,936,166.62 119,059,751.59 -30,876,415.03 1,350,522.74 Quarterly Portfolio Summary By Fund BRUSHY CREEK RUA | MARCH 31, 2024 7 Portfolio Overview SECURITY TYPE PAR VALUE MARKET VALUE BOOK VALUE % OF PORTFOLIO DAYS TO MATURITY YIELD Bank Deposits 1,150,108.78 1,150,108.78 1,150,108.78 0.97%1 0.66 Money Market Funds 76,848,547.39 76,848,547.39 76,848,547.39 64.55%1 4.88 Commercial Paper 24,000,000.00 23,603,245.42 23,603,245.42 19.82%111 5.59 U.S. Agencies 17,500,000.00 17,457,850.00 17,502,643.68 14.66%165 4.75 TOTAL 119,498,656.17 119,059,751.59 119,104,545.27 100.00%47 4.96 CASH AND ACCRUED INTEREST Purchased Accrued Interest 13,027.08 13,027.08 TOTAL CASH AND INVESTMENTS 119,498,656.17 119,072,778.67 119,117,572.35 47 4.96 TOTAL EARNINGS CURRENT QUARTER 1,350,522.74 BRUSHY CREEK RUA | MARCH 31, 2024 8 Summary by Type SECURITY TYPE # OF SECURITIES PAR VALUE BOOK VALUE % OF PORTFOLIO YIELD DAYS TO FINAL MATURITY CEDAR PARK-ESFD23 Bank Deposits 1 78,572.08 78,572.08 0.07 0.00 1 TOTAL 1 78,572.08 78,572.08 0.07 0.00 1 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 3,190,003.29 3,190,003.29 2.67 0.00 1 TOTAL 1 3,190,003.29 3,190,003.29 2.68 0.00 1 CONSTRUCTION FUNDS 2021 Bank Deposits 1 740.45 740.45 0.00 1.07 1 Money Market Funds 2 11,838,097.24 11,838,097.24 9.92 0.53 1 Commercial Paper 4 24,000,000.00 23,603,245.42 19.79 5.59 111 TOTAL 7 35,838,837.69 35,442,083.11 29.77 3.90 74 CONSTRUCTION FUNDS 2023 Money Market Funds 2 23,161,410.47 23,161,410.47 19.42 5.30 1 TOTAL 2 23,161,410.47 23,161,410.47 19.45 5.30 1 CONSTRUCTION FUNDS LEANDER 2009 Money Market Funds 1 2,802,718.09 2,802,718.09 2.35 0.00 1 TOTAL 1 2,802,718.09 2,802,718.09 2.35 0.00 1 CONSTRUCTION FUNDS-2018 SWIFT Money Market Funds 1 93,287.31 93,287.31 0.08 5.30 1 TOTAL 1 93,287.31 93,287.31 0.08 5.30 1 CP CP CP/LD CP/RR BRUSHY CREEK RUA | MARCH 31, 2024 9 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 0.02 0.02 0.00 1.12 1 Money Market Funds 1 25,960,470.75 25,960,470.75 21.76 5.30 1 U.S. Agencies 1 10,000,000.00 10,003,415.42 8.49 4.69 75 TOTAL 3 35,960,470.77 35,963,886.19 30.19 5.13 22 ESCROW FUNDS 2018 Bank Deposits 1 519.37 519.37 0.00 0.00 1 Money Market Funds 1 167,857.23 167,857.23 0.14 0.00 1 TOTAL 2 168,376.60 168,376.60 0.14 0.00 1 ESCROW FUNDS 2021 Money Market Funds 2 6,927,421.59 6,927,421.59 5.81 5.20 1 U.S. Agencies 1 7,500,000.00 7,499,228.26 6.32 4.82 285 TOTAL 3 14,427,421.59 14,426,649.85 12.09 5.00 149 OPERATING FUNDS Bank Deposits 1 700,800.14 700,800.14 0.59 1.09 1 Money Market Funds 1 2,707,281.42 2,707,281.42 2.27 0.00 1 TOTAL 2 3,408,081.56 3,408,081.56 2.86 0.22 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 ROUND ROCK-ESFD23 Bank Deposits 1 369,276.72 369,276.72 0.31 0.00 1 TOTAL 1 369,276.72 369,276.72 0.31 0.00 1 CP CP/LD BRUSHY CREEK RUA | MARCH 31, 2024 10 Summary by Type SECURITY TYPE # OF SECURITIES PAR VALUE BOOK VALUE % OF PORTFOLIO YIELD DAYS TO FINAL MATURITY GRAND TOTAL 26 119,498,656.17 119,104,545.27 100.00 4.36 47 BRUSHY CREEK RUA | MARCH 31, 2024 11 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-ESFD23 BANK DEPOSITS CCYUSD Cash 03/31/2024 03/31/2024 78,572.08 78,572.08 0.00 78,572.08 0.00 1 1.00 78,572.08 0.00 78,572.08 0.07 Aaa AAA BANK DEPOSITS TOTAL 78,572.08 78,572.08 0.00 78,572.08 0.00 1 1.00 78,572.08 0.00 78,572.08 0.07 Aaa AAA CEDAR PARK-ESFD23 TOTAL 78,572.08 78,572.08 0.00 78,572.08 0.00 1 1.00 78,572.08 0.00 78,572.08 0.07 Aaa AAA CEDAR PARK- ESFD23B BANK DEPOSITS CCYUSD Cash 03/31/2024 03/31/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 03/31/2024 03/31/2024 3,190,003.29 3,190,003.29 0.00 3,190,003.29 0.00 1 1.00 3,190,003.29 0.00 3,190,003.29 2.68 NA MONEY MARKET FUNDS TOTAL 3,190,003.29 3,190,003.29 0.00 3,190,003.29 0.00 1 1.00 3,190,003.29 0.00 3,190,003.29 2.68 NA CONSTRUCTION FUNDS TOTAL 3,190,003.29 3,190,003.29 0.00 3,190,003.29 0.00 1 1.00 3,190,003.29 0.00 3,190,003.29 2.68 NA CONSTRUCTION FUNDS 2021 BANK DEPOSITS 1550578940CP Wells Fargo Analyzed Busi- ness Checking Plus PF - C 03/31/2024 03/31/2024 740.45 740.45 0.00 740.45 1.07 1 1.00 740.45 0.00 740.45 0.00 NA BANK DEPOSITS TOTAL 740.45 740.45 0.00 740.45 1.07 1 1.00 740.45 0.00 740.45 0.00 NA MONEY MARKET FUNDS BRUSHY CREEK RUA | MARCH 31, 2024 12 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 TEXSTAR-CP TexStar Cedar Park 03/31/2024 03/31/2024 10,651,328.23 10,651,328.23 0.00 10,651,328.23 0.00 1 1.00 10,651,328.23 0.00 10,651,328.23 8.95 NA TEXSTAR-LD TexStar Leander 03/31/2024 03/31/2024 1,186,769.01 1,186,769.01 0.00 1,186,769.01 5.30 1 1.00 1,186,769.01 0.00 1,186,769.01 1.00 NA MONEY MARKET FUNDS TOTAL 11,838,097.24 11,838,097.24 0.00 11,838,097.24 0.53 1 1.00 11,838,097.24 0.00 11,838,097.24 9.94 NA COMMERCIAL PAPER 62479LEE1 MUFG BANK NY 05/14/24 11/14/2023 11/16/2023 5,000,000.00 4,860,250.00 0.00 4,860,250.00 5.75 05/14/2024 44 99.33 4,966,615.28 0.00 4,966,615.28 4.17 P-1 A-1 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 123 98.24 7,367,833.33 0.00 7,367,833.33 6.19 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 131 98.00 4,900,152.78 0.00 4,900,152.78 4.12 P-1 A-1+ 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 134 97.98 6,368,644.03 0.00 6,368,644.03 5.35 P-1 A-1+ COMMERCIAL PAPER TOTAL 24,000,000.00 23,190,266.67 0.00 23,190,266.67 5.59 111 98.35 23,603,245.42 0.00 23,603,245.42 19.82 P-1 AA CONSTRUCTION FUNDS 2021 TOTAL 35,838,837.69 35,029,104.36 0.00 35,029,104.36 3.90 74 65.83 35,442,083.11 0.00 35,442,083.11 29.77 AA CONSTRUCTION FUNDS 2023 MONEY MARKET FUNDS TEXSTAR-CP TexStar Cedar Park 03/31/2024 03/31/2024 7,578,003.97 7,578,003.97 0.00 7,578,003.97 5.30 1 1.00 7,578,003.97 0.00 7,578,003.97 6.36 NA TEXSTAR-RR TexStar Round Rock 03/31/2024 03/31/2024 15,583,406.50 15,583,406.50 0.00 15,583,406.50 5.30 1 1.00 15,583,406.50 0.00 15,583,406.50 13.09 NA MONEY MARKET FUNDS TOTAL 23,161,410.47 23,161,410.47 0.00 23,161,410.47 5.30 1 1.00 23,161,410.47 0.00 23,161,410.47 19.45 NA CONSTRUCTION FUNDS 2023 TOTAL 23,161,410.47 23,161,410.47 0.00 23,161,410.47 5.30 1 1.00 23,161,410.47 0.00 23,161,410.47 19.45 NA CONSTRUCTION FUNDS LEANDER 2009 MONEY MARKET FUNDS TEXSTAR-LD TexStar Leander 03/31/2024 03/31/2024 2,802,718.09 2,802,718.09 0.00 2,802,718.09 0.00 1 1.00 2,802,718.09 0.00 2,802,718.09 2.35 NA MONEY MARKET FUNDS TOTAL 2,802,718.09 2,802,718.09 0.00 2,802,718.09 0.00 1 1.00 2,802,718.09 0.00 2,802,718.09 2.35 NA BRUSHY CREEK RUA | MARCH 31, 2024 13 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 CONSTRUCTION FUNDS LEANDER 2009 TOTAL 2,802,718.09 2,802,718.09 0.00 2,802,718.09 0.00 1 1.00 2,802,718.09 0.00 2,802,718.09 2.35 NA CONSTRUCTION FUNDS-2018 SWIFT MONEY MARKET FUNDS TEXSTAR-CP TexStar Cedar Park 03/31/2024 03/31/2024 93,287.31 93,287.31 0.00 93,287.31 5.30 1 1.00 93,287.31 0.00 93,287.31 0.08 NA MONEY MARKET FUNDS TOTAL 93,287.31 93,287.31 0.00 93,287.31 5.30 1 1.00 93,287.31 0.00 93,287.31 0.08 NA CONSTRUCTION FUNDS-2018 SWIFT TOTAL 93,287.31 93,287.31 0.00 93,287.31 5.30 1 1.00 93,287.31 0.00 93,287.31 0.08 NA CONSTRUCTION FUNDS-2022 SWIFT BANK DEPOSITS 1550578932LN Wells Fargo Analyzed Busi- ness Checking Plus PF - L 03/31/2024 03/31/2024 0.02 0.02 0.00 0.02 1.12 1 1.00 0.02 0.00 0.02 0.00 NA BANK DEPOSITS TOTAL 0.02 0.02 0.00 0.02 1.12 1 1.00 0.02 0.00 0.02 0.00 NA MONEY MARKET FUNDS TEXSTAR-LD TexStar Leander 03/31/2024 03/31/2024 25,960,470.75 25,960,470.75 0.00 25,960,470.75 5.30 1 1.00 25,960,470.75 0.00 25,960,470.75 21.80 NA MONEY MARKET FUNDS TOTAL 25,960,470.75 25,960,470.75 0.00 25,960,470.75 5.30 1 1.00 25,960,470.75 0.00 25,960,470.75 21.80 NA U.S. AGENCIES 3130ATVC8 FHLBANKS 4.875 06/14/24 01/26/2023 01/30/2023 10,000,000.00 10,023,080.00 0.00 10,023,080.00 4.69 06/14/2024 75 99.87 9,987,400.00 (16,015.42) 10,003,415.42 8.39 Aaa AA+ U.S. AGENCIES TOTAL 10,000,000.00 10,023,080.00 0.00 10,023,080.00 4.69 75 99.87 9,987,400.00 (16,015.42) 10,003,415.42 8.39 Aaa AA+ CONSTRUCTION FUNDS-2022 SWIFT TOTAL 35,960,470.77 35,983,550.77 0.00 35,983,550.77 5.13 22 28.47 35,947,870.77 (16,015.42) 35,963,886.19 30.19 AA+ ESCROW FUNDS 2018 BANK DEPOSITS BRUSHY CREEK RUA | MARCH 31, 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 262006307CP Dreyfus Govt Cash Mgt Inst - Cedar Park 03/31/2024 03/31/2024 519.37 519.37 0.00 519.37 0.00 1 1.00 519.37 0.00 519.37 0.00 NA BANK DEPOSITS TOTAL 519.37 519.37 0.00 519.37 0.00 1 1.00 519.37 0.00 519.37 0.00 NA MONEY MARKET FUNDS TEXSTAR-CP TexStar Cedar Park 03/31/2024 03/31/2024 167,857.23 167,857.23 0.00 167,857.23 0.00 1 1.00 167,857.23 0.00 167,857.23 0.14 NA MONEY MARKET FUNDS TOTAL 167,857.23 167,857.23 0.00 167,857.23 0.00 1 1.00 167,857.23 0.00 167,857.23 0.14 NA ESCROW FUNDS 2018 TOTAL 168,376.60 168,376.60 0.00 168,376.60 0.00 1 1.00 168,376.60 0.00 168,376.60 0.14 NA ESCROW FUNDS 2021 MONEY MARKET FUNDS X9USDDGCM DREYFUS GVT CSH MGT;INST 03/31/2024 03/31/2024 1,705.63 1,705.63 0.00 1,705.63 5.20 1 1.00 1,705.63 0.00 1,705.63 0.00 Aaa AAA X9USDDGCM DREYFUS GVT CSH MGT;INST 03/31/2024 03/31/2024 6,925,715.96 6,925,715.96 0.00 6,925,715.96 5.20 1 1.00 6,925,715.96 0.00 6,925,715.96 5.82 Aaa AAA MONEY MARKET FUNDS TOTAL 6,927,421.59 6,927,421.59 0.00 6,927,421.59 5.20 1 1.00 6,927,421.59 0.00 6,927,421.59 5.82 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 285 99.61 7,470,450.00 (28,778.26) 7,499,228.26 6.27 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 285 99.61 7,470,450.00 (28,778.26) 7,499,228.26 6.27 P-1 A-1+ ESCROW FUNDS 2021 TOTAL 14,427,421.59 14,426,484.09 13,027.08 14,439,511.17 5.00 148 52.16 14,397,871.59 (28,778.26) 14,426,649.85 12.09 AAA OPERATING FUNDS BANK DEPOSITS 2550665125 Wells Fargo Analyzed Busi- ness Checking Plus PF 03/31/2024 03/31/2024 700,800.14 700,800.14 0.00 700,800.14 1.09 1 1.00 700,800.14 0.00 700,800.14 0.59 NA BANK DEPOSITS TOTAL 700,800.14 700,800.14 0.00 700,800.14 1.09 1 1.00 700,800.14 0.00 700,800.14 0.59 NA MONEY MARKET FUNDS TEXSTAR-MC TexStar Master Construction 03/31/2024 03/31/2024 2,707,281.42 2,707,281.42 0.00 2,707,281.42 0.00 1 1.00 2,707,281.42 0.00 2,707,281.42 2.27 NA CP LD OPERATING CP BRUSHY CREEK RUA | MARCH 31, 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 MONEY MARKET FUNDS TOTAL 2,707,281.42 2,707,281.42 0.00 2,707,281.42 0.00 1 1.00 2,707,281.42 0.00 2,707,281.42 2.27 NA OPERATING FUNDS TOTAL 3,408,081.56 3,408,081.56 0.00 3,408,081.56 0.22 1 1.00 3,408,081.56 0.00 3,408,081.56 2.86 NA ROUND ROCK ESFD23B BANK DEPOSITS CCYUSD Cash 03/31/2024 03/31/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 ROUND ROCK- ESFD23 BANK DEPOSITS CCYUSD Cash 03/31/2024 03/31/2024 369,276.72 369,276.72 0.00 369,276.72 0.00 1 1.00 369,276.72 0.00 369,276.72 0.31 Aaa AAA BANK DEPOSITS TOTAL 369,276.72 369,276.72 0.00 369,276.72 0.00 1 1.00 369,276.72 0.00 369,276.72 0.31 Aaa AAA ROUND ROCK-ESFD23 TOTAL 369,276.72 369,276.72 0.00 369,276.72 0.00 1 1.00 369,276.72 0.00 369,276.72 0.31 Aaa AAA GRAND TOTAL 119,498,656.17 118,711,065.34 13,027.08 118,724,092.42 4.36 47 34.78 119,059,751.59 (44,793.68) 119,104,545.27 100.00 AA+ BRUSHY CREEK RUA | MARCH 31, 2024 16 Cash Reconciliation Report CONSTRUCTION FUNDS 2021 POST DATE IDENTIFIER DESCRIPTION PAR VALUE FINAL MATURITY PRINCIPAL AMOUNT BUY 01/31/2024 55607KH17 MACQUARIE BNK 08/01/24 7,500,000.00 08/01/2024 7,301,750.00 -7,301,750.00 BUY TOTAL 7,500,000.00 7,301,750.00 -7,301,750.00 POST DATE IDENTIFIER DESCRIPTION PAR VALUE FINAL MATURITY PRINCIPAL AMOUNT MATURITY 02/16/2024 89119ABG2 The Toronto-Dominion Bank 0.0 02/16/2024 -5,000,000.00 02/16/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 03/08/2024 3130ATUQ8 FEDERAL HOME LOAN BANKS 4.75 03/08/2024 0.00 03/08/2024 0.00 356,250.00 COUPON TOTAL 0.00 0.00 356,250.00 POST DATE IDENTIFIER DESCRIPTION PAR VALUE FINAL MATURITY PRINCIPAL AMOUNT MATURITY 03/08/2024 3130ATUQ8 FEDERAL HOME LOAN BANKS 4.75 03/08/2024 -15,000,000.00 03/08/2024 -15,000,000.00 15,000,000.00 MATURITY TOTAL -15,000,000.00 -15,000,000.00 15,000,000.00 ESCROW FUNDS 2021 POST DATE IDENTIFIER DESCRIPTION PAR VALUE FINAL MATURITY PRINCIPAL AMOUNT BUY 01/31/2024 3130AYKN5 FHLBANKS 4.810 01/10/25 7,500,000.00 01/10/2025 7,499,062.50 -7,512,089.58 BUY TOTAL 7,500,000.00 7,499,062.50 -7,512,089.58 POST DATE IDENTIFIER DESCRIPTION PAR VALUE FINAL MATURITY PRINCIPAL AMOUNT COUPON 01/31/2024 91282CDV0 UNITED STATES TREASURY 0.875 01/31/2024 0.00 01/31/2024 0.00 65,625.00 COUPON TOTAL 0.00 0.00 65,625.00 POST DATE IDENTIFIER DESCRIPTION PAR VALUE FINAL MATURITY PRINCIPAL AMOUNT MATURITY BRUSHY CREEK RUA | MARCH 31, 2024 17 Cash Reconciliation Report 01/31/2024 91282CDV0 UNITED STATES TREASURY 0.875 01/31/2024 -15,000,000.00 01/31/2024 -15,000,000.00 15,000,000.00 MATURITY TOTAL -15,000,000.00 -15,000,000.00 15,000,000.00 BRUSHY CREEK RUA | MARCH 31, 2024 18 Transaction Statement CONSTRUCTION FUNDS 2021 TRADE DATE SETTLE DATE CUSIP DESCRIPTION PAR VALUE PRINCIPAL COST PURCHASED INTEREST TOTAL PURCHASE YIELD BUY 01/25/2024 01/31/2024 55607KH17 MACQUARIE BNK 08/01/24 7,500,000.00 7,301,750.00 0.00 (7,301,750.00)5.34 BUY TOTAL 7,500,000.00 7,301,750.00 0.00 (7,301,750.00)5.34 TRADE DATE SETTLE DATE CUSIP DESCRIPTION PAR VALUE BOOK VALUE TOTAL NET REALIZED GAIN/LOSS MATURITY 02/16/2024 02/16/2024 89119ABG2 The Toronto-Dominion Bank 0.0 02/16/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 ESCROW FUNDS 2021 TRADE DATE SETTLE DATE CUSIP DESCRIPTION PAR VALUE PRINCIPAL COST PURCHASED INTEREST TOTAL PURCHASE YIELD BUY 01/29/2024 01/31/2024 3130AYKN5 FHLBANKS 4.810 01/10/25 7,500,000.00 7,499,062.50 13,027.08 (7,512,089.58)4.82 BUY TOTAL 7,500,000.00 7,499,062.50 13,027.08 (7,512,089.58)4.82 TRADE DATE SETTLE DATE CUSIP DESCRIPTION PAR VALUE BOOK VALUE TOTAL NET REALIZED GAIN/LOSS MATURITY 01/31/2024 01/31/2024 91282CDV0 UNITED STATES TREASURY 0.875 01/31/2024 (15,000,000.00)15,000,000.00 15,000,000.00 0.00 MATURITY TOTAL (15,000,000.00)15,000,000.00 15,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 BRUSHY CREEK RUA | MARCH 31, 2024 19 Transaction Statement 03/08/2024 03/08/2024 3130ATUQ8 FEDERAL HOME LOAN BANKS 4.75 03/08/2024 (15,000,000.00)15,000,000.00 15,000,000.00 0.00 MATURITY TOTAL (15,000,000.00)15,000,000.00 15,000,000.00 0.00 BRUSHY CREEK RUA | MARCH 31, 2024 20 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)0.00 66,083.33 7,367,833.33 66,083.33 (132,166.67) 62479LEE1 MUFG BANK NY 05/14/24 5,000,000.00 4,860,250.00 (139,750.00)4,895,963.89 70,651.39 4,966,615.28 106,365.28 (33,384.72) 78015CHC9 ROYAL BK CA NYBR 08/12/24 6,500,000.00 6,233,337.50 (266,662.50)6,278,768.89 89,875.14 6,368,644.03 135,306.53 (131,355.97) 89233GH90 TOYOTA MOTOR CRD 08/09/24 5,000,000.00 4,794,929.17 (205,070.83)4,830,259.73 69,893.05 4,900,152.78 105,223.61 (99,847.22) 89119ABG2 The Toronto-Dominion Bank 0.0 02/16/2024 5,000,000.00 4,800,862.50 (199,137.50)4,965,691.67 34,308.33 0.00 199,137.50 0.00 TOTAL 29,000,000.00 27,991,129.17 (1,008,870.83)20,970,684.17 330,811.25 23,603,245.42 612,116.25 (396,754.58) 3130ATUQ8 FEDERAL HOME LOAN BANKS 4.75 03/08/2024 15,000,000.00 14,988,990.00 (11,010.00)14,998,141.89 1,858.11 0.00 11,010.00 0.00 3130ATVC8 FHLBANKS 4.875 06/14/24 10,000,000.00 10,023,080.00 23,080.00 10,007,615.47 (4,200.05)10,003,415.42 (19,664.58)3,415.42 TOTAL 25,000,000.00 25,012,070.00 12,070.00 25,005,757.36 (2,341.94)10,003,415.42 (8,654.58)3,415.42 ESCROW FUNDS 2021 3130AYKN5 FHLBANKS 4.810 01/10/25 7,500,000.00 7,499,062.50 (937.50)0.00 165.76 7,499,228.26 165.76 (771.74) 91282CDV0 UNITED STATES TREASURY 0.875 01/31/2024 15,000,000.00 14,954,296.88 (45,703.12)14,998,121.79 1,878.21 0.00 45,703.12 0.00 TOTAL 22,500,000.00 22,453,359.38 (46,640.62)14,998,121.79 2,043.97 7,499,228.26 45,868.88 (771.74) GRAND TOTAL 76,500,000.00 75,456,558.55 (1,043,441.45)60,974,563.32 330,513.28 41,105,889.10 649,330.55 (394,110.90) BRUSHY CREEK RUA | MARCH 31, 2024 21 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-ESFD23 CCYUSD Cash 2024-03-31 78,572.08 78,572.08 0.00 0.00 0.00 0.00 0.00 X9USDDGCM DREYFUS GVT CM;INST 2024-03-31 0.00 0.00 0.00 0.00 11,802.89 11,802.89 0.00 TOTAL 78,572.08 78,572.08 0.00 0.00 11,802.89 11,802.89 0.00 CEDAR PARK-ESFD23B CCYUSD Cash 2024-03-31 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-LD TexStar Leander 2024-03-31 0.00 0.00 0.00 0.00 41,192.31 41,192.31 0.00 TEXSTAR-MC TexStar Master Construction 2024-03-31 3,190,003.29 3,190,003.29 0.00 0.00 0.00 0.00 0.00 TOTAL 3,190,003.29 3,190,003.29 0.00 0.00 41,192.31 41,192.31 0.00 CONSTRUCTION FUNDS 2021 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 62479LEE1 MUFG BANK NY 05/14/24 2023-11-16 5,000,000.00 4,860,250.00 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-03-31 10,651,328.23 10,651,328.23 0.00 0.00 0.00 0.00 0.00 TEXSTAR-LD TexStar Leander 2024-03-31 1,186,769.01 1,186,769.01 0.00 0.00 33,584.15 33,584.15 0.00 1550578940CP Wells Fargo Analyzed Business Checking Plus PF - C 2024-03-31 740.45 740.45 0.00 0.00 740.45 740.45 0.00 TOTAL 35,838,837.69 35,029,104.36 0.00 0.00 34,324.60 34,324.60 0.00 CONSTRUCTION FUNDS 2023 TEXSTAR-CP TexStar Cedar Park 2024-03-31 7,578,003.97 7,578,003.97 0.00 0.00 53,622.08 53,622.08 0.00 TEXSTAR-RR TexStar Round Rock 2024-03-31 15,583,406.50 15,583,406.50 0.00 0.00 142,519.36 142,519.36 0.00 TOTAL 23,161,410.47 23,161,410.47 0.00 0.00 196,141.44 196,141.44 0.00 BRUSHY CREEK RUA | MARCH 31, 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 CONSTRUCTION FUNDS LEANDER 2009 TEXSTAR-LD TexStar Leander 2024-03-31 2,802,718.09 2,802,718.09 0.00 0.00 0.00 0.00 0.00 TOTAL 2,802,718.09 2,802,718.09 0.00 0.00 0.00 0.00 0.00 CONSTRUCTION FUNDS-2018 SWIFT TEXSTAR-CP TexStar Cedar Park 2024-03-31 93,287.31 93,287.31 0.00 0.00 138,328.09 138,328.09 0.00 TOTAL 93,287.31 93,287.31 0.00 0.00 138,328.09 138,328.09 0.00 CONSTRUCTION FUNDS-2022 SWIFT 3130ATUQ8 FEDERAL HOME LOAN BANKS 4.75 03/08/2024 2023-01-31 0.00 0.00 223,645.83 0.00 132,604.17 356,250.00 0.00 3130ATVC8 FHLBANKS 4.875 06/14/24 2023-01-30 10,000,000.00 10,023,080.00 23,020.83 0.00 121,875.00 0.00 144,895.83 TEXSTAR-LD TexStar Leander 2024-03-31 25,960,470.75 25,960,470.75 0.00 0.00 185,322.96 185,322.96 0.00 1550578932LN Wells Fargo Analyzed Business Checking Plus PF - L 2024-03-31 0.02 0.02 0.00 0.00 0.18 0.18 0.00 TOTAL 35,960,470.77 35,983,550.77 246,666.67 0.00 439,802.31 541,573.14 144,895.83 ESCROW FUNDS 2018 262006307CP Dreyfus Govt Cash Mgt Inst - Cedar Park 2024-03-31 519.37 519.37 0.00 0.00 6,247.16 6,247.16 0.00 TEXSTAR-CP TexStar Cedar Park 2024-03-31 167,857.23 167,857.23 0.00 0.00 748.38 748.38 0.00 TOTAL 168,376.60 168,376.60 0.00 0.00 6,995.54 6,995.54 0.00 ESCROW FUNDS 2021 X9USDDGCM DREYFUS GVT CSH MGT;INST 2024-03-31 6,927,421.59 6,927,421.59 0.00 0.00 39,329.34 46,237.83 0.00 3130AYKN5 FHLBANKS 4.810 01/10/25 2024-01-31 7,500,000.00 7,499,062.50 0.00 13,027.08 60,125.00 0.00 73,152.08 91282CDV0 UNITED STATES TREASURY 0.875 01/31/2024 2022-01-31 0.00 0.00 54,925.27 0.00 10,699.73 65,625.00 0.00 TOTAL 14,427,421.59 14,426,484.09 54,925.27 13,027.08 110,154.07 111,862.83 73,152.08 BRUSHY CREEK RUA | MARCH 31, 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 OPERATING FUNDS TEXSTAR TexSTAR 2024-03-31 0.00 0.00 0.00 0.00 38,206.13 38,206.13 0.00 TEXSTAR-MC TexStar Master Construction 2024-03-31 2,707,281.42 2,707,281.42 0.00 0.00 0.00 0.00 0.00 2550665125 Wells Fargo Analyzed Business Checking Plus PF 2024-03-31 700,800.14 700,800.14 0.00 0.00 3,062.08 3,062.08 0.00 TOTAL 3,408,081.56 3,408,081.56 0.00 0.00 41,268.21 41,268.21 0.00 ROUND ROCK ESFD23B CCYUSD Cash 2024-03-31 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 ROUND ROCK-ESFD23 CCYUSD Cash 2024-03-31 369,276.72 369,276.72 0.00 0.00 0.00 0.00 0.00 TOTAL 369,276.72 369,276.72 0.00 0.00 0.00 0.00 0.00 GRAND TOTAL 119,498,656.17 118,711,065.34 301,591.94 13,027.08 1,020,009.46 1,123,489.05 218,047.92 BRUSHY CREEK RUA | MARCH 31, 2024 24 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 78,572.08 7,526,481.89 78,572.08 03/31/2024 0.00 0.00 0.00 0.00 0.00 0.00 X9USDDGCM DREYFUS GVT CM;INST 0.00 0.00 0.00 03/31/2024 5.20 5.21 11,802.89 0.00 0.00 11,802.89 TOTAL 78,572.08 7,526,481.89 78,572.08 0.00 0.00 11,802.89 0.00 0.00 11,802.89 CEDAR PARK-ESFD23B CCYUSD Cash 100.00 0.00 100.00 03/31/2024 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL 100.00 0.00 100.00 0.00 0.00 0.00 0.00 0.00 0.00 CONSTRUCTION FUNDS TEXSTAR-LD TexStar Leander 0.00 3,3139,264.73 0.00 03/31/2024 0.00 5.30 41,192.31 0.00 0.00 41,192.31 TEXSTAR-MC TexStar Master Construction 3,190,003.29 4,912,365.36 3,190,003.29 03/31/2024 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL 3,190,003.29 8,051,724.50 3,190,003.29 0.00 0.00 41,192.31 0.00 0.00 41,192.31 CONSTRUCTION FUNDS 2021 1550578940CP Wells Fargo Analyzed Business Checking Plus PF - C 740.45 0.00 740.45 03/31/2024 0.00 1.07 740.45 0.00 0.00 740.45 55607KH17 MACQUARIE BNK 08/01/24 7,500,000.00 0.00 7,367,833.33 08/01/2024 0.00 5.34 0.00 66,083.33 0.00 66,083.33 62479LEE1 MUFG BANK NY 05/14/24 5,000,000.00 4,895,963.89 4,966,615.28 05/14/2024 0.00 5.75 0.00 70,651.39 0.00 70,651.39 78015CHC9 ROYAL BK CA NYBR 08/12/24 6,500,000.00 6,278,768.89 6,368,644.03 08/12/2024 0.00 5.66 0.00 89,875.14 0.00 89,875.14 89119ABG2 The Toronto-Dominion Bank 0.0 02/16/2024 0.00 4,965,691.67 0.00 02/16/2024 0.00 5.56 0.00 34,308.33 0.00 34,308.33 89233GH90 TOYOTA MOTOR CRD 08/09/24 5,000,000.00 4,830,259.73 4,900,152.78 08/09/2024 0.00 5.73 0.00 69,893.05 0.00 69,893.05 TEXSTAR-CP TexStar Cedar Park 10,651,328.23 13,014,029.33 10,651,328.23 03/31/2024 0.00 0.00 0.00 0.00 0.00 0.00 TEXSTAR-LD TexStar Leander 1,186,769.01 3,722,969.68 1,186,769.01 03/31/2024 0.00 5.30 33,584.15 0.00 0.00 33,584.15 TOTAL 35,838,837.69 37,707,683.18 35,442,083.11 0.00 3.90 34,324.60 330,811.25 0.00 365,135.85 CONSTRUCTION FUNDS 2023 TEXSTAR-CP TexStar Cedar Park 7,578,003.97 0.00 7,578,003.97 03/31/2024 0.00 5.30 53,622.08 0.00 0.00 53,622.08 BRUSHY CREEK RUA | MARCH 31, 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 TEXSTAR-RR TexStar Round Rock 15,583,406.50 0.00 15,583,406.50 03/31/2024 0.00 5.30 142,519.36 0.00 0.00 142,519.36 TOTAL 23,161,410.47 0.00 23,161,410.47 0.00 5.30 196,141.44 0.00 0.00 196,141.44 CONSTRUCTION FUNDS LEANDER 2009 TEXSTAR-LD TexStar Leander 2,802,718.09 0.00 2,802,718.09 03/31/2024 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL 2,802,718.09 0.00 2,802,718.09 0.00 0.00 0.00 0.00 0.00 0.00 CONSTRUCTION FUNDS-2018 SWIFT TEXSTAR-CP TexStar Cedar Park 93,287.31 140,457.54 93,287.31 03/31/2024 0.00 5.30 138,328.09 0.00 0.00 138,328.09 TOTAL 93,287.31 140,457.54 93,287.31 0.00 5.30 138,328.09 0.00 0.00 138,328.09 CONSTRUCTION FUNDS-2022 SWIFT 1550578932LN Wells Fargo Analyzed Business Checking Plus PF - L 0.02 0.00 0.02 03/31/2024 0.00 1.12 0.18 0.00 0.00 0.18 3130ATUQ8 FEDERAL HOME LOAN BANKS 4.75 03/08/2024 0.00 14,998,141.89 0.00 03/08/2024 4.75 4.82 132,604.17 1,858.11 0.00 134,462.28 3130ATVC8 FHLBANKS 4.875 06/14/24 10,000,000.00 10,007,615.47 10,003,415.42 06/14/2024 4.88 4.69 121,875.00 (4,200.05)0.00 117,674.95 TEXSTAR-LD TexStar Leander 25,960,470.75 10,418,803.85 25,960,470.75 03/31/2024 0.00 5.30 185,322.96 0.00 0.00 185,322.96 TOTAL 35,960,470.77 35,424,561.21 35,963,886.19 1.37 5.13 439,802.31 (2,341.94)0.00 437,460.37 ESCROW FUNDS 2018 262006307CP Dreyfus Govt Cash Mgt Inst - Cedar Park 519.37 497.18 519.37 03/31/2024 0.00 0.00 6,247.16 0.00 0.00 6,247.16 TEXSTAR-CP TexStar Cedar Park 167,857.23 165,655.68 167,857.23 03/31/2024 0.00 0.00 748.38 0.00 0.00 748.38 TOTAL 168,376.60 166,152.86 168,376.60 0.00 0.00 6,995.54 0.00 0.00 6,995.54 ESCROW FUNDS 2021 3130AYKN5 FHLBANKS 4.810 01/10/25 7,500,000.00 0.00 7,499,228.26 01/10/2025 4.81 4.82 60,125.00 165.76 0.00 60,290.76 91282CDV0 UNITED STATES TREASURY 0.875 01/31/2024 0.00 14,998,121.79 0.00 01/31/2024 0.88 1.03 10,699.73 1,878.21 0.00 12,577.94 X9USDDGCM DREYFUS GVT CSH MGT;INST 6,925,715.96 1,160,225.23 6,925,715.96 03/31/2024 5.18 5.20 37,623.71 0.00 0.00 37,623.71 BRUSHY CREEK RUA | MARCH 31, 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 X9USDDGCM DREYFUS GVT CSH MGT;INST 1,705.63 394,474.76 1,705.63 03/31/2024 5.18 5.20 1,705.63 0.00 0.00 1,705.63 TOTAL 14,427,421.59 16,552,821.78 14,426,649.85 4.99 5.00 110,154.07 2,043.97 0.00 112,198.04 OPERATING FUNDS 2550665125 Wells Fargo Analyzed Business Checking Plus PF 700,800.14 767,531.53 700,800.14 03/31/2024 0.00 1.09 3,062.08 0.00 0.00 3,062.08 TEXSTAR TexSTAR 0.00 2,056,162.04 0.00 03/31/2024 5.30 5.30 38,206.13 0.00 0.00 38,206.13 TEXSTAR-MC TexStar Master Construction 2,707,281.42 0.00 2,707,281.42 03/31/2024 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL 3,408,081.56 2,823,693.57 3,408,081.56 0.00 0.22 41,268.21 0.00 0.00 41,268.21 ROUND ROCK ESFD23B CCYUSD Cash 100.00 0.00 100.00 03/31/2024 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL 100.00 0.00 100.00 0.00 0.00 0.00 0.00 0.00 0.00 ROUND ROCK-ESFD23 CCYUSD Cash 369,276.72 41,616,781.11 369,276.72 03/31/2024 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL 369,276.72 41,616,781.11 369,276.72 0.00 0.00 0.00 0.00 0.00 0.00 GRAND TOTAL 119,498,656.17 150,010,357.64 119,104,545.27 1.02 4.36 1,020,009.46 330,513.28 0.00 1,350,522.74 BRUSHY CREEK RUA | MARCH 31, 2024 27 CUSIP DESCRIPTION POST DATE TRANSACTION TYPE AMOUNT CONSTRUCTION FUNDS 2021 MAY 2024 62479LEE1 MUFG Bank, Ltd., New York Branch 0.0 05/14/2024 05/14/2024 Maturity 5,000,000.00 MAY 2024 TOTAL 5,000,000.00 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 CONSTRUCTION FUNDS 2021 TOTAL 24,000,000.00 CONSTRUCTION FUNDS-2022 SWIFT JUN 2024 3130ATVC8 FEDERAL HOME LOAN BANKS 4.875 06/14/2024 06/14/2024 Maturity 10,000,000.00 3130ATVC8 FEDERAL HOME LOAN BANKS 4.875 06/14/2024 06/14/2024 Coupon 243,750.00 JUN 2024 TOTAL 10,243,750.00 CONSTRUCTION FUNDS-2022 SWIFT TOTAL 10,243,750.00 ESCROW FUNDS 2021 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 TOTAL 172,358.33 GRAND TOTAL 34,416,108.33 Projected Cashflows For the Period April 01, 2024 to September 30, 2024 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