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

Variable costs, percent of

revenues

Working capital, percent of

expected value

Conduct a sensitivity analysis for each variable and range and compute the NPV for each. Use Spreadsheet $10\mathrm{.}1$ and accompanying

data as a starting point for the analysis.

Note: Do not round intermediate calculations. Negative amounts should be indicated by a minus sign. Enter your answer in

millions rounded to $2$ decimal places.

$

$(413,000,000\mathrm{.}00$

$

$43,700,000\mathrm{.}00$

$

$(33,200,000\mathrm{.}00)$

$

$67,500,000\mathrm{.}00$

$

$(5,100,000\mathrm{.}00)$

$

$42,300,000\mathrm{.}00$

$

$(10,200,000\mathrm{.}00)$

$

$47,800,000\mathrm{.}00$

$

$(36,000,000\mathrm{.}00)$

$

$40,200,000\mathrm{.}00$

The column for expected is correct, the two columns labeled pessimistic and optimistic are all incorrect even if written as a decimal.