PLEASE SHOW ALL WORK EVEN IF DONE IN EXCEL PLEASE SHOW HOW YOU GOT EACH NUMBER TO SOLVE

Use the following information for problems 1 to 5. Assume that the projects are mutually exclusive. Year Cash Flow (A) Cash Flow (B) 0 ($49,725) ($49,725) 1 $25,200 $11,200 2 $18,200 $ 16,390 3 $13,800 $16,300 4 $7,600 $27,500 1. 2. What is the IRR for each of these projects? Using the IRR decision rule, which project should the company accept? Is this decision necessarily correct? If the required return is 10.25 percent, what is the NPV for each of these projects? Which project will the company choose if it applies the NPV decision rule? Over what range of discount rates would the company choose Project A? Project B? At what discount rate would the company be indifferent between these two projects? Explain. Compute the payback period for each project. Compute the profitability index for each project. 3. 4. 5