Conduct Sensitivity Analysis:

I am able to come up with the first row of answers (for the investment) and the expected NPV (by changing the % in the spreadsheet), but after that I am lost??

Here is the question (I've attached a word doc with the details because the website will not allow me to paste formatted tables. :

Blooper's analysts have come up with the following revised estimates for its magnoosium mine Project NPV: Pessimistic / Expected / Optimistic:

"Conduct a sensitivity analysis for each variable and range and compute the NPV for each. UseSpreadsheet 10.1and accompanying data as a starting point for the analysis"