Question 2

Really 30 PointsCorby Models is trying to select the best investment from among four alternatives.Each alternativel involves an initial outlay of $80,000. Their cash flows follow:YearIdaJackKellyLinda1$ 16,000$ 48,000$ 24,000$ -2$ 20,000$ 28,000$ 24,000$ -3$ 20,000$ 24,000$ 24,000$ 36,0004$ 36,000$ -$ 24,000$ 52,0005$ 44,000$ -$ 24,000$ 51,000Evaluate and rank each alternative based on a) payback period, b) net present value (use a 13% discount rate), and c) internal rate of return.Be sure to show your work in an excel file!Cost$80,000Discount Rate13%a) What is the Payback Period for for each alternative?IdaBlank 1JackBlank 2KellyBlank 3LindaBlank 4 Which alternative would you choose using the payback period?Blank 5b) What is the Net Present Value for each project using a 13% discount rate?IdaBlank 6JackBlank 7KellyBlank 8LindaBlank 9 Which alternative would you choose using the NPV using a 13% discount rate?Blank 10c) What is the IRR for each Project?IdaBlank 11JackBlank 12KellyBlank 13LindaBlank 14 Which alternative would you choose using the IRR