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

$\backslash$table$[[,$Range$],[$Initial investment,Pessimistic,Optimistic$],[$Revenues$,+35\%,-15\%],[$Variable costs, percent of$,-25\%,+15\%],[$revenues$,+20\%,-20\%],[$Fixed costs,$+25\%,-25\%],[$Working capital, percent of$,+25\%,-35\%],[$expected value,,$]]$

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$[[,$Project NPV$],[,$Pessimistic,Expected,Optimistic$],[$Initial $\backslash$table$[[$SHEET $10\mathrm{.}1$ Financial projections for Blooper's Magnoosium mine $[$dollar values in$,,,,,,,],[$A$.$ Inputs,,,,,,,$],[$Initial investment,$150,,,,,,],[$Salvage value,$20,,,,,,],[$Initial revenues,$150,,,,,,],[$Variable costs $[\%$ of revenu,$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,$15\mathrm{.}0\%,,,,,,],[$Tax rate $[\%),21\mathrm{.}0\%,,,,,,],[,,,,,,,],[,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 fix,$-150\mathrm{.}00,,,,,,15\mathrm{.}80],[,,,,,,,],[$C$.$ Dperating 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,],[$Dperating cash flow,,$45\mathrm{.}80,47\mathrm{.}78,49\mathrm{.}85,52\mathrm{.}03,54\mathrm{.}31,],[,,,,,,,],[$D$.$ Working capital,,,,,,,$],[$Working capital,Y$,,,,,,],[$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,$-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,,,,,,]]$

investment,,,$],[$Revenues$,,,],[$Variable costs,,,$],[$Fixed costs,,,$],[$Working capital,,,$]]$