I need to know the formulas and inputs required to solve this in Excel. Please show how to do it in Excel.

1. Your firm is considering two projects with the following cash flows. A B ml LOCO N 0009 Year 0 1 2 3 4 5 6 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,0001 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? (For discount rate Choose project B. For discount rate > 13.63% but smaller than 27.14% --> Choose project A)