How do you do in excel form?

10. NPV versus IRR. Zayas, LLC, has identified the following two exclusive projects: Year Cash Flow (A) Cash Flow (B) 2 3 4 -$78,500 43,000 29,000 23,000 21,000 -$78,500 21,000 28,000 34,000 41,000 What is the IRR for each of these projects? If you apply the IRR decision rule, which project should the company accept? Is this deciso necessarily correct? a. b. If the required return is 11 percent, what is the NPV for each of the projects? Which project will you choose if you apply the NPV decistd rule? Over what range of discount rates would you choose Project A? At what discount rate would you be indifferent between these two projects? Explain. c