In: Finance
Marge Simpson Inc. has following business opportunities with following cash flow information. Assume Marge’s opportunity cost of capital is 12%.
| 
 Year  | 
 Project A  | 
 Project B  | 
| 
 0  | 
 −$20,000  | 
 −$20,000  | 
| 
 1  | 
 15,000  | 
 2,000  | 
| 
 2  | 
 15,000  | 
 2,500  | 
| 
 3  | 
 13,000  | 
 3,000  | 
| 
 4  | 
 3,000  | 
 50,000  | 
Calculate profitability index for both projects.
Given about a two projects,
Calculating PI for Project A first,
initial cost C0 = $20000
cash flow over the next 4 years are
CF1 = $15000
CF2 = $15000
CF3 = $13000
CF4 = $3000
Cost of capital d = 12%
Profitability index of a project B= PV of future cash flows/initial investment
So, PV of future cash flows = CF1/(1+d) + CF2/(1+d)^2 + CF3/(1+d)^3 + CF4/(1+d)^4
=> PV of future cash flows = 15000/1.12 + 15000/1.12^2 + 13000/1.12^3 + 3000/1.12^4 = $36510.46
So, profitability index PI of project B = 36510.46/20000 = 1.826
Now Calculating PI for Project B,
initial cost C0 = $20000
cash flow over the next 4 years are
CF1 = $2000
CF2 = $2500
CF3 = $3000
CF4 = $50000
Cost of capital d = 12%
Profitability index of a project B = PV of future cash flows/initial investment
So, PV of future cash flows = CF1/(1+d) + CF2/(1+d)^2 + CF3/(1+d)^3 + CF4/(1+d)^4
=> PV of future cash flows = 2000/1.12 + 2500/1.12^2 + 3000/1.12^3 + 50000/1.12^4 = $37689.94
So, profitability index PI of project B = 37689.94/20000 = 1.884