data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet entered as 10.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. \begin{tabular}{l|l} WACC & 9.00% \end{tabular} (Dollars in Millions) Plan A Plan B Project IRR Calculations: IRRAIRRB#N/A#N/A NPV Profiles: \begin{tabular}{|r|r|r|} \hline \multicolumn{1}{|l|}{ Discount Rates } & \multicolumn{1}{c|}{NPVA} & \multicolumn{1}{c|}{NPVB} \\ \cline { 2 - 4 } & $0.00 & $0.00 \\ \hline 0% & $0.00 & $0.00 \\ \hline 5% & $0.00 & $0.00 \\ \hline 10% & $0.00 & $0.00 \\ \hline 15% & $0.00 & $0.00 \\ \hline 20% & $0.00 & $0.00 \\ \hline 22% & $0.00 & $0.00 \\ \hline 25% & $0.00 & $0.00 \\ \hline \end{tabular} NPV Profiles Calculation of Crossover Rate: Plan A Project Delta data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet entered as 10.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. \begin{tabular}{l|l} WACC & 9.00% \end{tabular} (Dollars in Millions) Plan A Plan B Project IRR Calculations: IRRAIRRB#N/A#N/A NPV Profiles: \begin{tabular}{|r|r|r|} \hline \multicolumn{1}{|l|}{ Discount Rates } & \multicolumn{1}{c|}{NPVA} & \multicolumn{1}{c|}{NPVB} \\ \cline { 2 - 4 } & $0.00 & $0.00 \\ \hline 0% & $0.00 & $0.00 \\ \hline 5% & $0.00 & $0.00 \\ \hline 10% & $0.00 & $0.00 \\ \hline 15% & $0.00 & $0.00 \\ \hline 20% & $0.00 & $0.00 \\ \hline 22% & $0.00 & $0.00 \\ \hline 25% & $0.00 & $0.00 \\ \hline \end{tabular} NPV Profiles Calculation of Crossover Rate: Plan A Project Delta