how do businesses calculate sensitivity analysis 
sensitivity analysis is often performed in analysis software and excel has functions to perform the analysis in general sensitivity analysis is calculated using formulas with different input cells for example a company may perform npv analysis using a discount rate of 6 sensitivity analysis can be performed by analyzing scenarios of 5 8 and 10 discount rates and maintaining the formula but referencing the different variable values 