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