Scenario table like in Excel

5.84K viewsData; data table ; scenario ; sensitivity excel
0

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.
Example:
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
0

Hi Juan,
Can you explain to me the difference between the “data table” function in Excel and the QM’s “scenario matrix” in terms of structure and logic? Where do you think, if not in the matrix, QM should store the “data table” result?
To make the conversation substantive, attach a specific example of an Excel model (or, may be, QM-model) of what you need.
Good luck.

Edited answer
You are viewing 1 out of 9 answers, click here to view all answers.