Sensitivity Table Macro

[LG2008]

Hi all,

I have a series of inputs in a model (i.e growth, exit price) that I would like to be able to flex. If these inputs are in cells A1 and B1 for example, the output (i.e the return) is shown in C1.

In a separate table, I want to list some different assumptions for each of these inputs and have the macro give me the output when using these inputs.

Anyone have a simple macro? many thanks

 

[ctd2015]

Hi google for data tables
This can help in 2 variable analysis for a range of values
https://www.wallstreetprep.com/blog/financial-modeling-techniques-sensitivity-what-if-analysis-2/