Excel Online Structured Activity: NPV profiles questions below.

X$$

Open spreadsheet $$10,550,000$ should be entered as $10\mathrm{.}55.$

Plan A: $ million

Plan B: $ million

Calculate each project's IRR. Round your answer to two decimal places.

Plan A: $\%$

Plan B: $\%$

b$.$ By graphing the NPV profiles for Plan A and Plan B$,$ approximate the crossover rate to the nearest percent.

$\%$

c$.$ Calculate the crossover rate where the two projects' NPVs are equal. Round your answer to two decimal places.

$1\%$ considered by your instructor.