In: Finance
| 
 Cori's Sausage Corporation is trying to choose between the following two mutually exclusive design projects:  | 
  
| Year | Cash Flow (I) | Cash Flow (II) | |||||
| 0 | –$ | 59,000 | –$ | 33,800 | |||
| 1 | 27,400 | 15,900 | |||||
| 2 | 27,400 | 15,900 | |||||
| 3 | 27,400 | 15,900 | |||||
| a-1. | 
 If the required return is 11 percent, what is the profitability index for each project?(Do not round intermediate calculations and round your answers to 3 decimal places, e.g., 32.161.)  | 
       
| a-2. | 
 If the company applies the profitability index decision rule, which project should the firm accept?  | 
  | 
| b-1. | 
 What is the NPV for each project? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)  | 
       
| b-2. | 
 If the company applies the NPV decision rule, which project should it take?  | 
  | 
Answer:-
Part a-1): Profitability index of Project I: 1.135
Profitability index of Project II: 1.150
Part a-2): If the company applies the profitability index decision rule, firm would accept Project II as it has higher profitability Index than Project I.
Part b-1): NPV for Project I: 7957.78
NPV for Project II: 5055.06
Part b-2): If the company applies the NPV decision rule, firm would accept Project I as it has higher NPV than Project II.
Explanation:-

Profitability Index = Present Value of Cash Flows / Initial Investment
Following is the excel sheet showing the calculation of NPV and profitability Index:-

Following is the Formula Sheet of above excel sheet for easy understanding of the formulas used:-
