World226_RM_07
Investment Banking Document / Model EditingUse the LBO analysis, update it to assume that Planet Fitness stock option tranches outstanding. I want to see the Year 5 IRR, flexing premium paid and exit multiple.
# Assumptions
-All options are vested or will vest in the event of a transaction
-3 tranches of stock options outstanding:
*5.0 million shares at a strike of $105.00/share
*4.0 million shares at a strike of $110.00/share
*5.0 million shares at a strike of $116.00/share
# Output
In the LBO analysis file create a new sensitivity table, with the Entry Premium % of 5% and 15%. Also show the Exit Multiple of 16x, 18x and 20x.
Round final monetary values to nearest million. Round all other values to 1 decimal point.
Your Answer
Expected: edit_existing_sheet
0 / 12,000
chars
Cmd/Ctrl+Enter to submit & evaluate
Evaluation
Submit your answer to see evaluation results.