World224-HS-06
Investment Banking Scenario / Sensitivity AnalysisPrompt
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 ...
Files
No task input snapshot for this task (`task_input_files` is null).
Gold Response
Year 5 Adj. EBITDA $763.26M EV value at Exit $26,714.26M Net Debt at Exit $580.85M Sponsor Equity Value at Exit $26,133.40M Sponsor Equity Value at Entry $11,275.85M MOIC 2.32x IRR % 18.31%
Rubric (7 criteria)
7 criteria
Traces (0)
No traces for this task
Input Analysis
- Prompt
- 162 words - 902 chars
- ~211 tokens
- Structure
- 12 sentences - 0 questions
- Ref. Files
- 1 files
- 1 xlsx
Output Analysis
- Output Type
- Message In Console
- Response
- text - 32 words - 7 lines
- ~42 tokens
- Prompt Tokens
- 211
- Gold Tokens
- 42
- Total Tokens
- 323
- Rubric
- 7 criteria