AndrePrevin
New member
- Joined
- Mar 2, 2022
- Messages
- 1
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Microsoft 365
[FONT="]Hi[/FONT]
[FONT="]I'm trying to set up a sensitivity analysis that will constantly update the table values if I enter a variance or change one of the input variables.[/FONT]
[FONT="]I have a table of variables which all impact the NPV of a project. The NPV values are in the table.[/FONT]
[FONT="]The problem is, I have to make the NPV values static every time I change a new variable, otherwise the new change overwrites the NPV values corresponding to the other variables.[/FONT]
[FONT="]For e.g., if I enter -5% to one of the variables in the table, the baseline project NPV (in the table) and the tornado chart values should automatically update.[/FONT]
[FONT="]If I reset that variable to 0 and change another variable, say to +10%, the baseline project NPV (in the table) and the tornado chart values should automatically update.[/FONT]
[FONT="]Etc.[/FONT]
[FONT="]Is this possible? Would greatly appreciate if someone could actually do a mock up for me and send me the Excel file.[/FONT]
[FONT="]I've attached an image of the Excel sheet with my attempt at the sensitivity table and an explanation of what I want.[/FONT]
[FONT="]Thank you[/FONT]
[FONT="]
[/FONT]
[FONT="]
[/FONT]
[FONT="]I'm trying to set up a sensitivity analysis that will constantly update the table values if I enter a variance or change one of the input variables.[/FONT]
[FONT="]I have a table of variables which all impact the NPV of a project. The NPV values are in the table.[/FONT]
[FONT="]The problem is, I have to make the NPV values static every time I change a new variable, otherwise the new change overwrites the NPV values corresponding to the other variables.[/FONT]
[FONT="]For e.g., if I enter -5% to one of the variables in the table, the baseline project NPV (in the table) and the tornado chart values should automatically update.[/FONT]
[FONT="]If I reset that variable to 0 and change another variable, say to +10%, the baseline project NPV (in the table) and the tornado chart values should automatically update.[/FONT]
[FONT="]Etc.[/FONT]
[FONT="]Is this possible? Would greatly appreciate if someone could actually do a mock up for me and send me the Excel file.[/FONT]
[FONT="]I've attached an image of the Excel sheet with my attempt at the sensitivity table and an explanation of what I want.[/FONT]
[FONT="]Thank you[/FONT]
[FONT="]
[FONT="]
| NPV values in red are linked to another cell in the workbook which automatically calculates a new NPV whenever the variance is applied. |
| Hence, I have to constantly change one variable, take the NPV from that other cell and paste as a value here |
