Please show all steps, formulas in excel format. Thank you

A company is considernn two exclusive expansion plans. Pinn A requires a 910 expenditure on a large-scale plant would cash of $6.39 million per for years. plan requires a million expenditure to budd somewhat less efficient, more labor intensive planr an cash now Of million per year for years. Thc: firm's WACC s a. Calculate each NPV. Enter Vour answers in millions. rot example, an answer of should be entered as 10.55, 00 not round intermerhate Round your answers tn tm decimal places. million Plan million Calculate each project's IRR. Round anSWers to one decimal place. Plan A: pian D: b. By graphing the NPV profiles for plan A and Plan B, determine the crossover rate. Round your answer to one decimal place. c. Calculate the crossover rate where the two projects' NPVs are equal. Round your answer to one decimal place. d. ts NPV better than IRR for making capital budgeting decisions that add to shareholder value? -SO IOCt- Please show all steps, formulas in excel format. Thank you.