Contact Us

World226_RM_01

Investment Banking Document / Model Editing
Investment Banking World 226 | task_32223647d43949e0b85fa92f4e69b526

Prompt

Update the LBO analysis tab "Copy of LBO". It needs to include a single potential add on acquisition in FY2027E. Assess the impacts on the 5-year LBO analysis. Use SOFR actual data. Add to that tab, the total debt, total enterprise value, and sponsor IRR. Round $ to millions and others to 1 decimal point.

General assumptions:
-Target EBITDA at time of acquisition is $41mm 
-Assume target EBITDA grows at the same CAGR as Planet Fitness standalone EBITDA forecast from 27-30
-Acquisition EBITDA mu...

Files

snap_a9945e0a5b324b80ab3f9aa51b8cd62f Use in Your Answer

Gold Response

snap_633521e73f7d4d0da01142901b326162

Rubric (3 criteria)

3 criteria

Traces (0)

No traces for this task

Input Analysis

Prompt
167 words - 1,032 chars
~217 tokens
Structure
11 sentences - 0 questions
Ref. Files
2 files
2 pdf

Output Analysis

Output Type
Edit Existing Sheet
Response
file - 1 words - 1 lines
~1 tokens
Prompt Tokens
218
Gold Tokens
2
Total Tokens
246
Rubric
3 criteria

Tools (9 Servers)