Investment Banking World 224

Reply back to me an updated IRR and MOIC. Round final numbers to two decimal places. Use the LBO and comps models to complete the analysis. Follow these assumptions: 1. Remove any comps with Enterprise Value/EBITDA multiples that are negative or greater than 4 times the current median. 2. Calculate the new median EV/EBITDA multiple and use that value +10.00x to replace the exit multiple on the 'LBO' tab of the LBO model 3. Update the senior debt amount on the 'LBO' tab to the minimum EV/Revenue multiple on the comps document

Return the Year 1 - Year 5 CAGR for Adjusted EBITDA. Round to two decimal places and display percentages with %. Write your answer straight back. I want you to use this info to update values in the LBO model: 1. Year 2 revenue growth rate increases 50 bps vs original case 2. Cost of revenue for 'subscription' increases by 15% YoY from Year 4 to Year 5

Make adjustments to the Year 5 growth rate to reach the following Year 1 - Year 5 CAGR for Total Revenue: 22%. Use the LBO model to complete the analysis, but just reply right here. Round value to one decimal place. Make these changes: 1. Year 1 revenue growth rate increases by 188 bps 2. Year 5 revenue growth rate increase by 1/8 the current % premium

Please use the LBO model to calculate the sponsor equity value and IRR for Year 5. Then report the sponsor equity value in US dollars, rounded to the nearest million (e.g., $1,000). Also, report the IRR as a percentage rounded to one decimal place. Send me your reply here. Follow these steps: - Increase the Senior Debt leverage to 6.0x from 5.0x. - Decrease the Senior Debt interest rate to 6.0% from 7.5%. - Reflect mandatory annual amortization of the Senior Debt, calculated as 2.0% of the opening principal balance of 2,088.3. - Increase the Subordinated Debt leverage to 2.0x from 1.5x. - Decrease the Subordinated Debt interest rate to 8.0% from 10.0%.

Please assess the impact of reducing the entry premium by 5% and illustrate the potential impact on the deal return. Use the LBO model. 1. Reduce the deal premium by 5%, from 35% to 30%. 2. Reduce the Exit Multiple from 35.0x to 34.0x. 3. Ensure all interest expense calculations are based on the average of the beginning and ending debt balance in the period. Report just the MOIC and IRR %, return it back here. All percentages and multiples must be rounded to two decimal places.

Please create a new scenario within the LBO model to assess the impact on Elastic’s Net Profit, assuming that for all years over the projection period (Year 1 to Year 5), Research and Development expenses margins are 10% higher and General and Administrative expenses margins are 2% higher. In the existing file, add a new tab and show values for "Net Profit" and "Net Profit Margin", across Year 1, Year 3, and Year 5. All monetary results must be displayed in USD millions, rounded to two decimal places, and all percentages must also be rounded to two decimal points.

Benchmark the results for Elastic NV Q2'FY26 (ending 10/31/2025) against their industry peers as reported in Public Comparables (for Q2). 1. Calculate the public comparables mean (average) for Market Cap, Enterprise Value, Enterprise Value/Revenue, and Enterprise Value/EBITDA 2. State the percent by which Elastic N.V. Underperformed or Overperformed its peers average across each valuation metric Constraints you MUST follow: 1. Express all multiples to two decimal places, and include 'x' after the second decimal 2. Express Market Cap and Enterprise Value as whole numbers 3. To manage large and extreme values, apply the following for the Public Comparables: 3a. Exclude Market Cap > $1 trillion in calculating the Market Cap average 3b. Exclude Enterprise Value > $1 trillion in calculating the Enterprise Value average 3c. Exclude Negative Multiples for Enterprise Value/Revenue and Enterprise Value/EBITDA 3d. Exclude Multiples > 200.00x for Enterprise Value/EBITDA Write your reply to me here with everything that I asked for.

Assess if the sponsor can still meet the 20% IRR target at the Year 5 exit, given higher cost of revenues. 1. Increase subscription cost as % of subscription revenues by 1 percentage point in Year 1, then keep it constant in the remaining projection years. 2. Increase services cost as % of services revenues by 1 percentage point in Year 1, then keep it constant in the remaining projection years. Add a new worksheet to the Elastic NV LBO model. It must show Net Debt at Exit, Sponsor Equity Value at Exit, IRR %. All monetary results to be displayed in USD millions, rounded to two decimal places, and all percentages must be rounded to two decimal points.

Assess how much certain business drivers must move to bring IRR below 20%. The stock price has fallen to $87.00. Use the LBO model for the info. 1. Find the critical point (percentages to 2 decimal places) for each of the below business drivers at which rounded IRR would be pushed down to 19.99% from above: a) 'Growth rate scale' (correct the approach for Year 1/2) b) 'Customer acquisition costs' c) 'R&D cost' d) 'Debt costs' e) 'EBITDA multiple' Assumptions and constraints: 1. EBITDA is not to fall below $91 million for any year. If this threshold is passed the new constraint becomes EBITDA for each individual year instead of the IRR. 2. 'Debt costs' should be set to 0% for all other sensitivities. Create a new sheet that shows values for the five major business drivers.

Please create a new scenario within the LBO model to assess if the sponsor can still meet the 20% IRR target at the Year 5 exit, given higher Net Working Capital needs. 1. Increase accounts receivable as % of sale by 2 percentage points value in Year 1, then keep it constant in the remaining projection years 2. Increase prepaid expenses and other current assets as % of sale by 2 percentage points in Year 1, then keep it constant in the remaining projection years. Output: Add a new worksheet to the LBO model titled “NWC Scenario”. Add the Net Debt at Exit, Sponsor Equity Value at Exit, IRR %. All monetary results must be displayed in USD millions, rounded to two decimal places, and all percentages must also be rounded to two decimal points.

Print out here the updated IRR and MOIC, rounded to two decimal places. Use the precedent transactions document and LBO model to complete the analysis. Assumptions: 1. Adjust the LBO model to have the premium % equal to Splunk Inc's revenue growth rate in the precedent transactions document 2. Adjust year 4 revenue growth in the LBO to New Relic, Inc's revenue growth rate in the precedent transactions document

I want you to tell me for Year 1 - Year 5: (1) Total revenue CAGR(2) Subscription Cost of Revenue CAGR (3) Sales and Marketing Expenses CAGR (4) EBITDA CAGR But first adjust revenue growth rate to be 7.5% in year 1, 50 bps YoY increase to year 2, 150 bps YoY increase to year 3, 100 bps increase vs original case in year 4, and original case for year 5. Reply here, with 2 decimal points.

Run a single downside scenario where all modeled sensitivity factors receive a 20% shock, in the direction that would adversely impact IRR. What would the new IRR & Sponsor Equity Value be? Use the LBO model to answer. In the operating assumptions, update the sensitivity shocks of the major business drivers, including: a) -20% 'Growth rate scale', total revenue growth for Elastic for years 1-5 b) 20% 'Customer acquisition costs', total sales and marketing costs for years 1-5 for Elastic c) 20% 'R&D cost', the costs for research and development that Elastic is expected to pay from year 1 to 5 in the future d) 20% 'Debt costs', the interest costs that Elastic would have to pay e) -20% 'EBITDA multiple', the exit multiple that is used in determining the exit valuation Output, in a NEW tab in the existing LBO model, values for “IRR (All factors shocked by 20%)” and “Sponsor Equity Value (All factors shocked by 20%)”. Round all values to two decimal places, and display monetary values in millions ($m). I also want you to give an assessment of whether further analysis is required, based on whether the downside loses money.

Please evaluate the impact on Elastic's IRR% at exit, assuming a slowdown in Total Revenues growth. Return the following here: Year 5 Adj. EBITDA, EV value at Exit, Net Debt at Exit, Sponsor Equity Value at Exit, Sponsor Equity Value at Entry, MOIC, and IRR %. use the LBO model. Respond with your answers straight back here. Use this for your work: 1. Decrease the existing Total Revenues growth rate in Year 3 by 5% of its original value in the base case (a 5% relative decrease). 2. Decrease the existing Total Revenues growth rate in Year 4 by 10% of its original value in the base case (a 10% relative decrease). 3. Decrease the existing Total Revenues growth rate in Year 5 by 15% of its original value in the base case (a 15% relative decrease). All monetary results must be displayed in USD millions, rounded to 2 decimal places, and all percentages must also be rounded to 2 decimal points.

Use the LBO model to assess the impact of a lower interest rate environment on the Year 5 exit IRR% target. 1. Decrease the existing senior debt cost by 50 bps starting at the beginning of Year 2. The senior debt cost should remain constant thereafter. 2. Decrease the existing subordinated debt cost by 25 bps starting at the beginning of Year 3. The subordinated debt cost should remain constant thereafter. 3. Recalculate the total interest cost for the impacted projection period (Year 2 to Year 5). 4. Note that all interest expense calculations must be based on the average of the beginning and ending debt balance in the period. Tell me the Net Debt at Exit, Sponsor Equity Value at Exit, MOIC, and IRR %. Print it here. All monetary results must be displayed in USD millions, rounded to two decimal places, and all percentages and multiples must also be rounded to two decimal points.

Using the assumptions below, calculate the sponsor equity value and IRR for Year 5. Then, report the sponsor equity value in US dollars, rounded to the nearest million (e.g., $1,000). Report the IRR as a percentage rounded to one decimal place. Print your answer here. Use the LBO model with the following specifications: - Increase the Subordinated Debt leverage to 2.0x from 1.5x. - Implement mandatory annual amortization of the Subordinated Debt, calculated as 1.5% of the opening principal balance of 696.1. - For each of Years 1 through 5, calculate mandatory annual amortization on Subordinated Debt as 1.5% of the opening principal balance. - Subtract both the mandatory annual amortization and any additional paydown from the beginning Subordinated Debt balance to arrive at the ending Subordinated Debt balance for that year. - Repeat this sequence each year so that the Subordinated Debt schedule reflects both annual amortization and any paydowns across Years 1 through 5. - To determine the ending Senior Debt balance from Year 1 through Year 5, incorporate the following: - Discretionary Repayment (excess cash sweep) is calculated as 50.0% of the Available Cash for Debt Repayment. - Compute discretionary repayment as 50.0% of Available Cash for Debt Repayment and deduct this amount from the beginning balance of Senior Debt to arrive at the ending balance. - This sequence is repeated each year so the debt schedule reflects discretionary paydowns tied to Available Cash for Debt Repayment. - Each year, Total Debt Paydown should equal the sum of all Senior Debt paydowns plus both the mandatory and any additional repayments on Subordinated Debt.

Use the LBO model. I want some new analyses: - Decrease the “Premium” from 35.0% to 25.0% on the "LBO" tab - Decrease the “Adj. EBITDA Multiple” from 40.0x to 25.0x on the "LBO" tab - Update revenue growth constant at 15.0% per year from Year 2 through Year 5. Write out to me here: 1. Sponsor Equity Value in Year 5. 2. IRR in Year 5. Round it to the nearest million (e.g., $1,000). Report the IRR as % rounded to one decimal place.