Solve using excel showing fomulas

1. Your firm is considering two projects with the following cash flows. Year WN - 1911 NO Project A 22,500 8,000 8,000 8,000 8,000 8,000 8,000 Project B -50,000 15,000 15,000 15,000 15,000 15,000 15,000 5 6 In which discount rate range will the company prefer Project A, in which discount rate range will the company prefer Project B, and in which discount rate range will the company not invest? 1. Your firm is considering two projects with the following cash flows. Year WN - 1911 NO Project A 22,500 8,000 8,000 8,000 8,000 8,000 8,000 Project B -50,000 15,000 15,000 15,000 15,000 15,000 15,000 5 6 In which discount rate range will the company prefer Project A, in which discount rate range will the company prefer Project B, and in which discount rate range will the company not invest