Perform scenario analysis as follows: Scenario Probability Cost Savings WACC Salvage Value (New) Worst case 25% 20,000 16% 8,000 Base case 50% 30,000 13% 10,000 Best case 25% 40,000 11% 12,000 What are the NPV, IRR, MIRR, payback period and discounted payback period for each scenario? It is required to establish scenarios by using scenario manager to get credits for this problem.

Please show how to do in excel

Answer rating: 100% (QA)

To perform the scenario analysis and calculate the NPV IRR MIRR payback period and discounted paybac... View the full answer