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
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.