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

Range

Pessimistic Optimistic

Initial investment $+30\%15\%$

Revenues $20\%+20\%$

Variable costs, percent of revenues $+25\%25\%$

Fixed costs $+20\%20\%$

Working capital, percent of expected value $+35\%30\%$

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.$\backslash$table$[[$SPREADSHEET $10\mathrm{.}1$ Financial projections for Blooper's Magnoosium mine $($dollar values in millions$)],[$A$.$ Inputs$],[$Initial investment,$150,,,,,,],[$Salvage value,$20,,,,,,],[$Initial revenues,$150,,,,,,],[$Variable costs $(\%$ of revenues$),40\mathrm{.}0\%,,,,,,],[$Initial fixed costs,$40,,,,,,],[$Inflation rate $(\%),5\mathrm{.}0\%,,,,,,],[$Discount rate $(\%),12\mathrm{.}0\%,,,,,,],[$Receivables $(\%$ of sales$),16\mathrm{.}7\%,,,,,,],[$Inventory $(\%$ of next year's costs$),15\mathrm{.}0\%,,,,,,],[$Tax rate $(\%),21\mathrm{.}0\%,,,,,,],[$Year:$,0,1,2,3,4,5,6],[$B$.$ Capital Investments$],[$Investments in fixed assets,$150\mathrm{.}00,,,,,,],[$Sales of fixed assets,,,,,,,$15\mathrm{.}80],[$Cash flow investment in fixed assets,$-150\mathrm{.}00,,,,,,15\mathrm{.}80],[$C$.$ Operating cash flow$],[$Revenues$,,150\mathrm{.}00,157\mathrm{.}50,165\mathrm{.}38,173\mathrm{.}64,182\mathrm{.}33,],[$Variable expenses,,$60\mathrm{.}00,63\mathrm{.}00,66\mathrm{.}15,69\mathrm{.}46,72\mathrm{.}93,],[$Fixed expenses,,$40\mathrm{.}00,42\mathrm{.}00,44\mathrm{.}10,46\mathrm{.}31,48\mathrm{.}62,],[$Depreciation$,,30\mathrm{.}00,30\mathrm{.}00,30\mathrm{.}00,30\mathrm{.}00,30\mathrm{.}00,],[$Pretax profit,,$20\mathrm{.}00,22\mathrm{.}50,25\mathrm{.}13,27\mathrm{.}88,30\mathrm{.}78,],[$Tax$,,4\mathrm{.}20,4\mathrm{.}73,5\mathrm{.}28,5\mathrm{.}86,6\mathrm{.}46,],[$Profit after tax,,$15\mathrm{.}80,17\mathrm{.}78,19\mathrm{.}85,22\mathrm{.}03,24\mathrm{.}31,],[$Operating cash flow,,$45\mathrm{.}80,,49\mathrm{.}85,52\mathrm{.}03,54\mathrm{.}31,],[$D$.$ Working capital$],[$Working capital,$15\mathrm{.}00,40\mathrm{.}75,42\mathrm{.}79,44\mathrm{.}93,47\mathrm{.}17,30\mathrm{.}39,0\mathrm{.}00],[$Change in working capital,$15\mathrm{.}00,25\mathrm{.}75,2\mathrm{.}04,2\mathrm{.}14,2\mathrm{.}25,-16\mathrm{.}79,-30\mathrm{.}39],[$Cash flow from investment in working can,$-15\mathrm{.}00,-25\mathrm{.}75,-2\mathrm{.}04,-2\mathrm{.}14,-2\mathrm{.}25,16\mathrm{.}79,30\mathrm{.}39],[,0\mathrm{.}408,0\mathrm{.}408,0\mathrm{.}408,0\mathrm{.}408,0\mathrm{.}250,],[$E$.$ Project valuation$],[$Total project cash flow,$-165\mathrm{.}00,20\mathrm{.}05,45\mathrm{.}74,47\mathrm{.}71,49\mathrm{.}78,71\mathrm{.}10,46\mathrm{.}19],[$Discount factor,$1\mathrm{.}00,0\mathrm{.}8929,0\mathrm{.}7972,0\mathrm{.}7118,0\mathrm{.}6355,0\mathrm{.}5674,0\mathrm{.}5066],[$PV of cash flow,$-165\mathrm{.}00,17\mathrm{.}90,36\mathrm{.}46,33\mathrm{.}96,31\mathrm{.}64,40\mathrm{.}34,23\mathrm{.}40],[$Net present value,$18\mathrm{.}70,,,,,,]]$