AI Agents for REIT Conversion Analysis

Using the REIT model, consider the following assumptions for the projected period between 2025 to 2029: 1) Assume the revenue growth for its service business equivalent to the overall company revenue growth 2) Assume that the EBITDA margin for the service business is 5 percentage points higher than the company EBITDA margin during the same forecast period 3) Assume depreciation equivalent to 2% of the annual revenues 4) Assume capex equal to 3% of the annual revenue 5) Assume investment in working capital equal to 1.5% of the annual revenue 6) Assume the effective tax rate is equal to 21% 7) Assume that the spin-off is done on a debt free, cash free basis 8) Assume the valuation date as of December 31, 2024 9) Assume a cost of equity of 12% and a terminal growth rate of 1% post the projected period. Compute the levered free cash flows and the implied equity value of its service business. Round all the values up to two decimals: - Cumulative Levered Free Cash Flows (2025 - 2029) - Terminal Value - Equity Value of the service business Reply here.

Perform a DCF analysis for Golden Everest using the REIT model with the following parameters: - Hold EBITDA margin constant at 42% throughout the projection period - Hold Capex % of Revenue constant at 22% throughout the projection period - Assume a WACC of 9% - Assume Terminal Value is equal to 11 times final projection year EBITDA - Assume Net Debt is as given for 2024A - End-of-year discounting (not mid-year convention) Give me your reply showing the Golden Everest Equity Value in $ millions, rounded to the nearest million.

Using the REIT model re-calculate the Implied REIT Price Per Share using the the 25th Percentile EV/EBITDA and 2025E Revenue Growth percentage of 5%. Return to me right here the price in $ for the same case used in the Executive Summary tab. Round to 2 decimal points.

Forecast operational expenses are impacted by a rising inflation of 2% in the REIT model. The increase is able to be passed on only for Services revenues. Assume the proportion of operating expenses deriving from Service revenue is equal to its proportion of total revenue in 2024. Calculate the inflation-adjusted enterprise value and target share price in 2025 for Golden Everest based on REIT industry capitalization rate of 5.5%. Print the answer here. Present monetary values in $ million rounded to nearest whole number, and share prices in $ to 2 decimal places.

Calculate which data center company in the peer group has generated the strongest revenue growth, and highest Adjusted EBITDA margins over 2022-2024. 1. Only analyze the period of 2022-2024 2. Rank each company in the peer group on their revenue growth from 2021-2024 (CAGR) 3. Rank each company in the peer group on their EBITDA margin 4. The company with the highest average ranking of the two metrics is considered the strongest, if there is a tie, the company with the largest increase in EBITDA margin (absolute percentage point increase from 2022 to 2024) is considered stronger 5. Adjusted EBITDA should be calculated by taking net income and adding back income taxes, interest expense, depreciation and amortization 6. Three companies should be analyzed: American Tower, Equinix, Digital Realty 7. For American Tower, only utilize financials from the data center portion of the business from 2022-2024 for calculations Tell me the strongest company; and return the averages of all the companies for: 1. annualized revenue growth, 2. average Adjusted EBITDA Margin, and 3. adjusted EBITDA margin increase. All percentages should be rounded to 2 decimal places. Print the answer here.

In the existing sheet for the REIT model, create a sensitivity table for 2029E Net Income. Show Revenue Growth Step-up at 50 basis points and 100 basis points. Show EBITDA Margin Step-up at 20 basis points and 40 basis points. Round all final numbers to the nearest million. To calculate the correct values, assume that revenue growth in 2025E starts at 8.0% and increases by the same amount every year of the projection period, referred to as the "Revenue Growth Step-up". Assume that EBITDA Margin % starts at 44.0% and increases by the same amount every year of the projection period, referred to as the "EBITDA Margin Step-up".

Using the 'Projections (C-Corp)' tab in Golden_Everest_REIT_Analysis compute the Net Income for 2029E given the following scenario: - Assume tax rates are 15.0% for 2025E through 2029E - If net income exceeds $1,300M in a given year, update the revenue growth % for all subsequent years. - Use the average of the growth rates shown on the "Projected Financials" slide in the Project_Titan_Presentation v3.pptx file. Compare the 2029E Net Income computed for the above scenario to the original 2029E Net Income by providing each Net Income figure and their dollar difference. Present in $M and round to nearest whole number. Write back your answers as a message.

Calculate the price per share that a strategic buyer would need to offer for Golden Everest to consider an acquisition instead of a REIT conversion. Reply to me here with the minimum required share price. Round all final numbers to two decimal places. I want the 2027 expected share price discounted to 11/21/2025 (18 months) for “C-Corp Low”, “C-Corp Mid”, “C-Corp High”, “REIT Low”, “REIT Mid”, and “REIT High”. Assumptions: 1. It will take 18 months post REIT conversion for the stock to appreciate to fair value, assuming mid-2027 for this process to complete. 2. The discount rate is 4%. 3. Use the low, mid, and high multiples found in the model. 4. Assume the price needed to consider the acquisition is 10% above the valuation for the REIT using the mid multiple. 5. Reference 2025E EV/EBITDA multiples for C-Corp and REIT conversion, and pull 2027E EBITDA values from the model.

Calculate Unlevered Free Cash Flow in 2025E, 2026E, 2027E, 2028E and 2029E. In the Golden Everest Financial Model, there is an error in the unlevered free cash flow build in the Projections, "Projections (C-Corp)", tab. Please use the correct formula to calculate Unlevered Free Cash Flow based on the Projections. Additionally, use the following assumptions: - Change in Working Capital: -1.0% of Revenues between 2025E and 2029E - D&A: 11.50% of Revenues in 2025E and 12.0% of Revenues from 2026E through 2029E - Capex: 24.0% of Revenues in 2025E, 22.0% of Revenues in 2026E, 21.0% of Revenues in 2027E, and 20% of Revenues in 2028E and 2029E Round output financial figures to 2 decimal points. $ must be in millions. Give me your response as a reply right here.

Model out the NPV of distributions shareholders would receive under REIT conversion. - There's the $1.2 billion E&P purge that gets taxed as ordinary income at 37% (E&P purge occurs at Year 0, annual distributions occur at end of Years 1–5). - There are ongoing REIT dividends in the $650-750mm range that qualify for the 20% Section 199A deduction. - Apply 199A only to annual REIT distributions; do not apply 199A to the E&P purge (tax purge at 37%). - Run sensitivities across 10%, and 12% discount rates over a 5-year horizon. Show discount rates vs distribution levels, populated with respective after-tax NPV per share. Then, show me the base case NPV as a percentage of both the strategic offer and current trading price. Round NPV per share to 2 decimal places. Round percentages to 1 decimal place. Create an xlsx that has all of your results.

Golden Everest's management team plans to issue a 10-year debenture of $3,000 million at an interest rate of 5% at the end of 2025E. Use the REIT model to model Golden Everest's year-end cash balances in 2025E, 2026E, and 2027E under C-Corp, no change in the dividend policy with the debenture. Additionally, model Golden Everest's year-end cash balances in 2025E, 2026E, and 2027E under the REIT structure and with the debenture. Assume under the REIT structure, management decides to distribute 92.5% of net income as a dividend. Write a message to me, explaining the following: - Golden Everest's year-end cash balances in 2025E, 2026E, and 2027E under C-corp structure. - Golden Everest's year-end cash balances in 2025E, 2026E, and 2027E under REIT structure. Present monetary values in $ million rounded to nearest whole number.

Calculate the weighted average cost of capital (WACC) for Golden Everest. Write back your reply, accounting for the following: - Utilize the REIT structure mid case scenario for 2025E in the model. - Presume the REIT pays 90% of its taxable income. - Use the REIT's net debt level, instead of gross debt for WACC calculations, and presume the interest rate stays the same as the C-corp. - The corporate tax rate is 15% for both C-corp and REIT. - State the weighted average cost of capital as a percentage, round to 2 decimal places.

Using the REIT model, recalculate the fair value of Golden Everest with C-Corp status using a three-stage unlevered DCF. For Stage 1, use the unlevered cash flows from 2025E to 2029E on the “Projections (C-Corp)” tab. Assume the valuation date is December 1, 2025 and use the midyear adjustment approach for Stage 1, which assumes CFs are generated halfway through each period rather than at period-end for any partial periods. For Stage 2, grow unlevered FCF at a 5% annual pace for 12 years until 2041). For stage 3, use a perpetuity growth rate of 1%. Assume WACC is 11%. For present value calculations, use a 365 day count. Get me back (1) present value of stage 1 cash flows; (2) present value of stage 2 cash flows; (3) present value of terminal value; and (4) equity value per share. State all values in millions and rounded to the nearest whole number, except equity value per share, which you should show in dollars and cents. Print your reply here.

Edit the Valuation Summary tab of the REIT model, showing the implied upside/downside percentage for the Mid case of Scenario 1: Current Valuation. - EV/EBITDA multiple: use 50% and 55% of the average multiple for Data Center REITs on the Comparable Companies tab, excluding the highest and lowest companies by market cap. - Current trading price: two columns as 10% and 20% higher than the Strategic Offer share price. Assume revenue growth % is now 9% and EBITDA Margin % is now 41% for the entirety of the projection period and use 2029E EBITDA instead of 2025E EBITDA in the Mid case of Scenario 1: Current Valuation. Round to the nearest two decimal points.

I want the Output Levered FCF for 2029E, rounded to the nearest million. - Revenue growth: starts at 7.0% and increases by 0.5% per year in the projection period - EBITDA margin %: starts at 44.0% and increases by 0.1% per year in the projection period - Capex % of revenue: starts at 23.0% and decreases by 0.5% per year in the projection period - Tax rate: 20.0% every year of the projection period Use the Projections (C-Corp) tab in the REIT model. Give me the answer right back here.

Using the information in the REIT model, create a new sheet: - Re-run the Scenario3: REIT Conversion analysis in sheet "Valuation Summary" using FFO multiples in place of the current EBITDA multiples - Run a low case using Iron Mountain's FFO multiple - Run a High case using Digital Realty's FFO multiple Tell me this info for Low and High cases: - REIT Equity Value ($mm) - Implied REIT Price Per Share - Premium to Current Share price of $42.50 as of 11/21/25 Calculate Golden Everest's 2025E FFO metric by using Digital Realty's implied FFO value (from the information within the "Comparable Companies" tab ) as % of LQA Adjusted EBITDA for the period QE 3/31/2023 within the investor presentation Format all outputs as follows: - Round all dollar figures to 1 decimal place in millions ($m) and express in "$X.X" format - Round all percentages to 1 decimal place - Share price should be to two decimal places

For each year, calculate Levered FCF less Dividends Paid. Assuming a 9% discount rate, output the net present value (NPV) of Levered FCF less Dividends Paid over the projection period, rounded to a full million. Refer to REIT model and adjust Golden Everest Base Case Projections (C-Corp Status) as follows: - Hold Capex % of Revenue constant at 22% over the projection period - Assume Dividend per Share is fixed at 1.60 in 2025E, increasing 0.40 per year over the projection period. Print your answer to me here via a short message.

Using the REIT model, assess the downside REIT scenario for Golden Everest if data center REIT multiples compress 30% during a longer than expected conversion period of 12 months. Reply to me in here with a message which states the expected price in 12 months of Golden Everest in this downside scenario and the expected total return of the stock over that period. Round all numbers to 2 decimal points. Assumptions: 1. Stock price will be calculated off of 2026 expected earnings 2. Dividends are not re-invested 3. Only half of the REIT premium (post-compression) vs C-Corps will be realized over the 12 months 4. No change in net debt