How to create data stress tests in excel

[machok98]

I need to create a table that shows how net income changes if one of variables in the formula changes. For example, if margin on one of the investments changes by 5bps. I heard there is an easy way to do this in excel. Can anyone please help? THanks in advance.

 

[pgc01]

Hi machok98
Welcome to the board

It's the Data Table tool.

Here's an example:

http://www.homeandlearn.co.uk/excel2007/excel2007s7p1.html

Remarks:
- The data table can also accept 2 variables instead of 1 as in the example
- In older versions of excel it's located directly under the Data menu

Hope this helps
PGC