answer the following usung excel / excel formula

Basic (Questions 1-22) LOI 1. Calculating Payback What is the payback period for the following set of cash flows? Year Cash Flow 0 -$7.800 3.100 2 3,200 3 2.200 4 1,400 LOI 13. Calculating Payback Stenson, Inc., imposes a payback cutoff of three years for its international investment projects. If the company has the following two projects available, should it accept either of them? Year Cash Flow (A) Cash Flow (B) 0 -$75,000 -$125.000 1 33,000 29,000 2 36,000 32,000 3 19.000 35,000 4 9,000 240,000 LO35. Calculating IRR A firm evaluates all of its projects by applying the IRR rule. If the required return is 11 percent, should the firm accept the following project? Year Cash Flow 0 -$157,300 74.000 1 2 87.000 46,000 LO3, L04 11. NPV versus IRR Consider the following two mutually exclusive projects: Year Cash Flow (X) Cash Flow (Y) -$23.900 0 -$23,900 1 13.100 9.300 2 9,480 10.620 3 7,890 11,180 Sketch the NPV profiles for X and Y over a range of discount rates from 0 to 25 percent. What is the crossover rate for these two projects? LO6 13. Calculating Profitability Index What is the profitability index for the following set of cash flows if the relevant discount rate is 10 percent? What if the discount rate is 15 percent? If it is 22 percent? Year 0 Cash Flow -$29.500 16,900 1 2 13.600 3 8,300