Monday 4 May 2015

Mutually Exclusive Divisible projects Example


Mutually Exclusive Divisible projects Example
Mr. A has $ 500 fund and want to invest those fund in some project. He has the following divisible projects. Project B & D are mutually exclusive

Project
 Funds Requirement
NPV
A
 210
35
B
 250
45
C
 230
40
D
 300
60

Help Mr. A for right selection of projects

Solution
1.    Calculate profitability Index
Project
 Funds Requirement
NPV
P. Index
A
 200
35
=35/210 =.166
B
 250
45
=45/250 =.18
C
 230
40
=40/230 = .175
D
 300
60
=60/300 =.2

2.    Rank the project (according to Profitability Index)
Profitability Index
Ranking
.2
D
.18
B
.175
C
.166
A

3.    Combination of projects D & B

Combination will be decided on the bases of profitability index
Combination B
Combination D
B,C,A
D,C

D,A







4.    B, C, A Combination

P.I
Fund requirement
Balance
NPV
B
.18
250
250
45
C
.175
230
  20
40
A
.166
  20
0
3.5 (10% of 35)
Total



88.5

5.    D, C

P.A
Fund requirement
Balance
NPV
D
.200
300
200
60
C
.175
200 (87%)
  0
35 (87% of 40)
A
.166
 
0
95


Combination of D,C will be selected because it will provide higher NPV