Respuesta :
Answer: best case Nvp $2,943,304,509.57
Worse case NVP
-$2, 601,609,39
Answer:
The best case NPV gives $2,943,309.57
The worst case NPV gives ($2,601,609.39)
Explanation:
In calculating the NPVs in the attached excel file, the following points should be noted:
Under the best case the +10% is added to price and volume while -10% is applied to costs
Under the worst case NPV -10% is applied to price and volume while +10% was applied to costs
Under both scenarios,depreciation was deducted earlier in order to calculate tax appropriately,but later added to net income in order calculate net cash flows since depreciation is not a cash flow.
In calculating the present of cash flows the pv formula in excel was used.
Finally NPV is present value cash flow less initial investment.