Provide me with the ANSWERS TO THESE QUESTIONS USING EXCEL AND PLEASE PROVIDE ME WITH THE FORMULAS;

What is the payback period of the project?

What is the profitability index of the project?

What is the IRR of the project?

What is the NPV of the project?

How sensitive is the NPV to changes in the price of the new smartphone?

How sensitive is the NPV to changes in the quantity sold?

Should Conch Republic produce the new smartphone?

Suppose Conch Republic loses sales on other models because of the introduction of the new model. How would

this affect your analysis?