submit answers in Excel. Assume the following for all questions: Year (t) Project A $2,000 10 1 This question has two parts a) and b). Refer to the table below to answer them. Please 2 300 300 7,000 Projects are mutually exclusive; r =5%, 10 %, and 15%. a. Calculate for each project: 1. Payback period 2. Discounted payback period 3. Net present value 4. IRR Project B $5,000 500 500 1,500 Project C -$3,000 400 400 2,500 b. Indicate which project you would undertake. Justify your answer with one sentence.