Scenario table like in Excel

5.84K viewsData; data table ; scenario ; sensitivity excel

I want to build a table like the “data table” in Excel. To calculate different scenarios.
i dont like the scenario options of adding a category with different values to calculate the scenario.
rows: EBITDA ( lets say 10; 12; 14)
columns: multiple (6; 7; 8)
is there any function to do that same sensitivity analysis like in Excel? In Excel is very easy. You set the values for roes and columns and the output.

many thanks, Quanters

Answered question

Thats perfect SAU. still have a problem 🙂 My model doesnt allow me to perform the calculation directly for the table. There many matrixes ad the ouput comes from many calculations in those matrixes. So I cant directly type the formula for the table. I have multiples, ebitdas and IRR. The irr comes from calculation s in those matrixes so I dont really know how to get the desired output. May I send my model and take a look?
Sorry for the work 🙂

Answered question
You are viewing 1 out of 9 answers, click here to view all answers.