Using ms excel compute the sensitivity analysis of changes


Using MS Excel, compute the sensitivity analysis of changes in parameters (+/- 50%, steps of 10%), one at of the following data: •Initial investment: 15000. •MARR:10%. •Yearly Savings: $6,000. •Project Life: 10 years. •Salvage value: $1000. Present a table AND a single graph containing all effects of changes in the project parameters 2. Using MS Excel and the data of the prior problem, compute the sensitivity analysis of two parameters at a time (Project Life and Yearly Savings) from+/-30%, steps of 5%

Request for Solution File

Ask an Expert for Answer!!
Financial Management: Using ms excel compute the sensitivity analysis of changes
Reference No:- TGS01419374

Expected delivery within 24 Hours