Problem 8.1: Answer the following questions and submit your excel file for the calculation in Connect. Please use excel file to calculate the following questions. Layout your initial input separately and clearly and do all the calculation inside of excel file. (Excel part: 10 points) Consider the following two mutually exclusive projects: The required return on these investments is 11 percent. a. What is the payback period for each project? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) b. What is the NPV for each project? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) c. What is the IRR for each project? (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) d. What is the profitability index for each project? (Do not round intermediate calculations and round your answers to 3 decimal places, e.g., 32.161.) e. Based on your answers in (a) through (d), which project will you finally choose