World226_TD_03
Investment Banking Document CreationPrompt
Conduct a 5-year IRR sensitivity analysis using Planet Fitness' latest financial model that Advent updated based on their specifications (v7). Assess the impact if Planet Fitness reduces National advertising fund expense to 10% YoY change in Q1 to Q4 2026. Using the "Copy of LBO" tab calculate the 5-year IRR when offer prices are $100, $110 and exit multiples are 16x, 17x. Round all calculated results to one decimal place. Create a sensitivity table, and make a new Spreadsheet, with these valu...
Files
snap_c93b0308db204f93baab1e21cded8bb3 Use in Your Answer
Gold Response
snap_7ffe7101fc4b474995f0ccd991eaa490
Rubric (4 criteria)
4 criteria
Traces (0)
No traces for this task
Input Analysis
- Prompt
- 82 words - 503 chars
- ~107 tokens
- Structure
- 5 sentences - 0 questions
- Ref. Files
- 1 files
- 1 pdf
Output Analysis
- Output Type
- Make New Sheet
- Response
- file - 1 words - 1 lines
- ~1 tokens
- Prompt Tokens
- 107
- Gold Tokens
- 2
- Total Tokens
- 185
- Rubric
- 4 criteria