World226_SK_Task03

Investment Banking Scenario / Sensitivity Analysis

Investment Banking World 226 | task_9c300623b46a4b09b40f4976208bf8af

Prompt

Calculate the sponsor equity value and IRR for FY2030, then report the sponsor equity value in US dollars as a reply. Round $ to the nearest million and report the IRR %  to one decimal place.

1. Reference the "Copy of LBO" tab in the LBO model for interim calculations. 
2. Develop one scenario with the following specifications: 
-- Increase the Cash to $600 from $500 and the Minimum Cash to $100 from $50
-- Decrease the Exit Multiple from 18.0x to 15.0x
-- Increase the “Secured term loan - USD...

Files

Use in Your Answer

No task input snapshot for this task (`task_input_files` is null).

Gold Response

Sponsor Equity Value in FY2030 is $12,736.
IRR in FY2030 is 9.3%.

Rubric (2 criteria)

2 criteria

Traces (0)

No traces for this task

Input Analysis

Prompt: 130 words - 734 chars
: ~169 tokens
Structure: 11 sentences - 0 questions

Output Analysis

Output Type: Message In Console
Response: text - 12 words - 2 lines
: ~16 tokens
Prompt Tokens: 169
Gold Tokens: 16
Total Tokens: 204
Rubric: 2 criteria