i need excel formulas with problem

(5) Problem #5 Chapter 3 - Capital Budgeting - IRR for mutually exclusive projects (conventional) Boston Chicken is considering two mutually exclusive projects with the following cash flows. What is the crossover rate? if the required rate of return is lower than the crossover rate, which project should be accepted? A. 14.72 percent; and Project A B. 14.72 percent; and Project B C. 15.99 percent; and Project A D. 15.99 percent; and Project B E. 16.08 percent; and Project B Solution (do & show in Excel and Type Answer here or Copy & Paste/Replace the solution from Excel to here): Additional Sept Additional Step 2: Calculate Difference Calculate Cromoverrate of CFA ) is of errenta GFS Crossover rate BAII Plus Year Cash Flows (A) -560,000.00 $31.000.00 $25,000.00 $27.000.00 Cash Flows 550,000.00 562.000.00 $21,000.00 $18,000.00 IRR results . IRRA IRR ) Crossover rate A&B Explanation