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.

Similar Questions
  1. Explain how to use the table function to perform calculations in Excel?The table function in Excel includes a special row called
    1. answers icon 1 answer
  2. What is the purpose of using the table function in Excel? Please select your answer... A The table function in Excel is used
    1. answers icon 1 answer
  3. ow can you apply filters to a table in Excel?Filters can be applied to a table in Excel by creating a separate filter range and
    1. answers icon 1 answer
  4. How can you apply filters to a table in Excel?Filters can be applied to a table in Excel by creating a separate filter range and
    1. answers icon 1 answer
more similar questions