(10 marks) Consider the following investment proiects with a reauired return of 15% : Solutions in Excel a. Calculate the payback period for each project. ( 2 marks) b. Calculate the discounted payback period for each project. (2 marks) c. Find the profitability index for each project. (1 mark) d. What are the net present values of each project? (2 marks) e. Which project should you choose? ( 1 mark) f. How many IRR's could each project have? (2 marks)