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

$\backslash$table$[[,$Range$],[,$Pessimistic,$0$ptimistic$],[$Initial investment,$+45\%,-20\%$

$\backslash$table$[[$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,,,,,,$3,],[\backslash$table$[[$Revenues$]],,150\mathrm{.}00,157\mathrm{.}50,165\mathrm{.}38,173\mathrm{.}64,182\mathrm{.}33,],[$Variable expenses,,$60\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,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,\backslash$table$[[27\mathrm{.}88]],\backslash$table$[[30\mathrm{.}78]],],[$Tax$,52,4\mathrm{.}20,4\mathrm{.}73,\backslash$table$[[5\mathrm{.}28]],\backslash$table$[[5\mathrm{.}86,]],6\mathrm{.}46,$G$],[$Profit after tax,,$15\mathrm{.}80,\backslash$table$[[17\mathrm{.}78]],19\mathrm{.}85,22\mathrm{.}03,24\mathrm{.}31,$D$],[$Operating cash flow,,$45\mathrm{.}80,\backslash$table$[[47\mathrm{.}78]],\backslash$table$[[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,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 cap,$-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,\backslash$table$[[45\mathrm{.}74]],\backslash$table$[[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,,,,,,]]$