Contact Us

World225_RL_Task01

Investment Banking Document / Model Editing
Investment Banking World 225 | task_baf778f717af41a880538e1f85bdde12
In the existing sheet for the REIT model, create a sensitivity table for 2029E Net Income. Show Revenue Growth Step-up at 50 basis points and 100 basis points. Show EBITDA Margin Step-up at 20 basis points and 40 basis points. Round all final numbers to the nearest million. To calculate the correct values, assume that revenue growth in 2025E starts at 8.0% and increases by the same amount every year of the projection period, referred to as the "Revenue Growth Step-up". Assume that EBITDA Margin % starts at 44.0% and increases by the same amount every year of the projection period, referred to as the "EBITDA Margin Step-up".

Your Answer

Expected: edit_existing_sheet
0 / 12,000 chars

Cmd/Ctrl+Enter to submit & evaluate

Evaluation

Submit your answer to see evaluation results.