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

Range

PessimisticOptimisticInitial investment+40%-20%Revenues-20%+25%Variable costs+20%-15%Fixed cost+50%-50%Working capital+35%-35%

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.(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.)