****PLEASE ADD EXCEL FORMULAS TO EACH ONE. FIRST YELLOW BOX IS E21.

Choosing between two projects with acceptable payback periods Shell Camping Gear Inc. is considering two mutually exclusive projects. Each requires an initial investment (CF0) of $100,000. John Shell, president of the company, has set a maximum payback period of 4 years. The after-tax cash inflows associated with each project are shown in the following table. a. Determine the payback period of each project. b. Because they are mutually exclusive, Shell must choose one. Which should the company invest in? c. Explain why one of the projects is a better choice than the other. Answers (insert your answers in the highlighted cells; use cell references, equations, and functions wherever possible) a. Determine the navback neriod of each nroiect. Because they are mutually exclusive, Shell must choose one. Which should the company invest in? Explain why one of the projects is a better choice than the other