Using the data in the tables above, answer the following questions:
• Calculate the NPV for each project using each scenario’s NPV rate. Show your work.
• Calculate the pay-back period for each project. Show your work.
• Calculate the IRR for each project. Show your work.
• Which project would the company select using the NPV method in scenario 1? Explain your answer.
• Which project would the company select using the NPV method in scenario 2? Explain your answer.
• Which project would the company select using the NPV method in scenario 3? Explain your answer.
• Which project would the company select using the pay-back period? Explain your answer.
• Which project would the company select using the IRR method? Explain your answer.