Excel Online Structured Activity: NPV profiles

Open spreadsheet 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.

$Y$

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

$Y$ instructor.