World225_RL_Task01
Investment Banking Document / Model EditingIn 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.