Excel Online Structured Activity: NPV profiles

Micropoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.

Plan $A$:$$,$ million

Plan $B$:$$,$ million

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

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.

$\%$