Sensitivity analysis

AndrePrevin

New member
Joined
Mar 2, 2022
Messages
1
Reaction score
0
Points
0
Excel Version(s)
Microsoft 365
[FONT=&quot]Hi[/FONT]

[FONT=&quot]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=&quot]I have a table of variables which all impact the NPV of a project. The NPV values are in the table.[/FONT]
[FONT=&quot]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=&quot]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=&quot]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=&quot]Etc.[/FONT]

[FONT=&quot]Is this possible? Would greatly appreciate if someone could actually do a mock up for me and send me the Excel file.[/FONT]
[FONT=&quot]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=&quot]Thank you[/FONT]

[FONT=&quot]
1646254218994-png.59182
[/FONT]




[FONT=&quot]
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
[/FONT]
 

Attachments

  • Tornado.xlsx
    15 KB · Views: 4

AliGW

Administrator
Joined
Nov 8, 2015
Messages
1,786
Reaction score
1
Points
38
Location
Ipswich, Suffolk, England
Excel Version(s)
MS 365 (Beta Insider Channel)
Top