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?

Annual cash flows:

Year $0$

Year $1$

Year $2$

Year $3$

I

$

$(51,000)$

II

$

$(14,400)$

$

$7,800$

$

$7,800$

Required return

$10\%$

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 $($I

NPV $($I$)$

NPV $($II$)$

Answer must be in formula mode