Show how to solve these problems using excel.

What is the payback period for the following set of cash flows? Problem 2 An investment project costs $15,000 and has annual cash flows of $4,300 for six years. What is the discounted payback period if the discount rate is 0% ? What if the discount rate is 5% ? If it is 19% ? Problem 3 A project that provides annual cash flows of $28,500 for nine years costs $138,000 today. Is this a good project if the required return is 8% ? What if it is 20% ? At what discount rate would you be indifferent between accepting the project and rejecting it? Problem 4 What is the IRR of the following set of cash flows? 1 Problem 5 Consider the followino two mutually oxclusive nroiects. Whichever project you choose, if any, you require a 15\% return on your investment. a) If you apply the payback criterion, which investment will you choose? Why? b) If you apply the discounted payback criterion, which investment will you choose? Why? c) If you apply the NPV criterion, which investment will you choose? Why? d) If you incorrectly apply the IRR criteria (not I-IRR), which investment will you choose? e) If you correctly apply the I-IRR criteria, which investment will you choose? Why? Based on your answers in (a) through (e), which project will you finally choose? Why