How is the excel table supposted to look like and the structure of the answer(which calculations go first)?
1. Determine the NPV, IRR, PAYBACK, Discounted Payback, and MIRR for the opening of one average new store in 2016. Assume same sales as in 2014 but costs are 5% higher.
2. Perform a worst case scenario analysis: Sales are 30% lower than in 2014 and costs are 20% higher and the stock’s risk (beta) is 50% higher than it was on December 1 2015. Determine the NPV, IRR, PAYBACK, Discounted Payback, and MIRR for the opening of one average new store in 2016.