submit answers in Excel. Assume the following for all questions: Year (t) Project A $2,000 10...

  

Transcribed Image Text:

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. 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.

Answer rating: 100% (QA)

It appears you would like help with calculating the payback period discounted payback period net present value NPV and internal rate of return IRR for three different projects as well as advice on whi... View the full answer