HELP SOLVE USING EXCEL FORMAULAS $.$ The Michner Corporation is trying to choose between the following two mutually exclusive design projectsthe required return is percent, what is the profitabilty index for each project? What is the for each perfect The Michner Corporation is trying to choose between the following two mutually exclusive design projects. If the required return is $10$ percent, what is the profitabilty index for eaech project? What is the NPV for each project? Input area: Year Year $1$ Year $2$ Year $3$ Required return Project $($$$82,000)$ $$37,600$ $$37,600$ $$37,60010\%$ Project II $($$$21,700$ $$11,200$ $$11,200$ $$11,200($Use cells A$6$ to $011$ from the given information to complete this question. You must use the built$-$in Exc question.$)$ Output area: Profitability index Profitability index il NPVI NPV II