Question: I need help with this please: This is the question directly from the website : Capture 2.png Blooper's analysts have come up with the following


I need help with this please:
This is the question directly from the website : Capture 2.png
Blooper's analysts have come up with the following revised estimates for its magnoosium mine:
Range
Pessimistic Optimistic
Initial investment + 40 % - 25 %
Revenues - 20 % + 20 %
Variable costs + 25 % - 20 %
Fixed cost + 40 % - 20 %
Working capital + 40 % - 35 %
Conduct a sensitivity analysis for each variable and range and compute the NPV for each. Use Spreadsheet 10.1 and accompanying data as a starting point for the analysis. (Do not round intermediate calculations. Negative amounts should be indicated by a minus sign. Enter your answers in thousands rounded to the nearest whole dollar.)


Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
