I need the actual FORMULAs to solve and answers these questions. I need to write out the formulas in the yellow output area. Use both columns B & C with Rows B7-B11 and C7-C11.

I used this formula and had some wrong answers.

=NPV(B11,B8:B10)/-C7.

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? 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