Scenario table like in Excel

5.85K 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

Hi Juan,
This is my version of the QM model for calculating the VE sensitivity to changes in EBITDA and Multiple. In addition to the EBITDA and Multiple inputs, you can also change the values ​​for 1) EBITDA change step (ECS) and 2) Multiple change step (MCS). You can also change the number of items in the categories EBITDALst (Ei) and MultipleLst (Mj) – the model automatically recalculates all totals and item descriptors. The model contains two perspectives and some items notes.
I hope this is what you need.
Good luck.

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