Blooper's analysts have come up with the following revised estimates for its magnoosium mine:

Range

Pessimistic Optimistic

Initial investment + 45 % - 25 %

Revenues - 15 % + 25 %

Variable costs + 25 % - 25 %

Fixed cost + 20 % - 25 %

Working capital + 20 % - 30 %

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.