The Sloan Corporation is trying to choose between the following two mutually exclusive

design projects. If the required return is $10$ percent, what is the profitability index for each

project? What is the NPV for each project?

Complete the following analysis. Do not hard code values in your calculations. You

must use the built$-$in Excel function to answer this question.

Profitability index $($I$)$

Profitability index $($II$)$

NPV $($I$)$

NPV $($II$)$