Perform sensitivity and scenario analysis on project NPV. Build tornado charts ranking input sensitivity, two-variable data tables, and Monte Carlo simulation of NPV distribution across uncertain input variables.
Enter the values for the scenario you are assessing. Perform sensitivity and scenario analysis on project NPV. Build tornado charts ranking input sensitivity, two-variable data tables, and Monte Carlo simulation of NPV distribution across uncertain input variables. Use the npv sensitivity result to inform your calculation.