|
|
© 2000 John Petroff |
4)- Mutually exclusive projects of different size
To illustrate the methods of analysis we take project 1 and project 2. They are not mutually exclusive in the description of the case, but they may be as a result of capital rationing. In Table T-10.6, the intranet project has a higher IRR and PI, but the conveyor project has a higher NPV. In Table T-10.9 below the difference between annual cash flows is calculated and shown in the third column.
|
|
|||
|
|
|||
| . | Conveyor | Intranet | Difference |
| . | 1 | 2 | =1-2 |
|
Beta |
0.8 | 0.9 | 0.8 |
|
Discount rate |
0.092 | 0.096 | 0.092 |
| IRR | 10% | 13% | 10% |
| PI |
1.05 |
1.21 |
1.02 |
| NPV | $67.09 | $34.30 | $28.42 |
| ANVP | $3.35 | $2.45 | $1.42 |
| 2000 | -1450 | -180 | -1270 |
| 2001 | 250 | 30 | 220 |
| 2002 | 200 | 30 | 170 |
| 2003 | 200 | 30 | 170 |
| 2004 | 200 | 30 | 170 |
| 2005 | 200 | 30 | 170 |
| 2006 | 200 | 30 | 170 |
| 2007 | 200 | 30 | 170 |
| 2008 | 200 | 30 | 170 |
| 2009 | 200 | 30 | 170 |
| 2010 | 100 | 30 | 70 |
| 2011 | 100 | 30 | 70 |
| 2012 | 100 | 30 | 70 |
| 2013 | 100 | 30 | 70 |
| 2014 | 100 | - | 100 |
| 2215 | 100 | - | 100 |
| 2016 | 100 | - | 100 |
| 2017 | 100 | - | 100 |
| 2018 | 100 | - | 100 |
| 2019 | 100 | - | 100 |
This difference can be thought of as a separate additional third project that allows a comparison of the first two. The projects have different lives, but using the annualized NPV is not necessary because we only need to determine if we should accept undertaking the difference. Table T-10.9 shows that the difference has a positive NPV and annualized NPV. This implies that this third project should be chosen, which is tantamount to choosing project 1.
By contrast, to the conclusion above, Table T-10.10 below uses the same presentation to compare projects 1 and 8.
|
|
|||
|
|
|||
| . | Conveyor | New prod1 | Difference |
| . | 1 | 8 | =1-8 |
| Beta | 0.8 | 1.9 | 0.8 |
| Discount rate | 0.092 | 0.136 | 0.092 |
| IRR | 11% | 16% | 8% |
| NPV | $109.02 | $47.76 | ($54.31) |
| ANVP | $5.45 | $6.82 | ($2.72) |
| 2000 | -1450 | -500 | -950 |
| 2001 | 300 | 5 | 295 |
| 2002 | 200 | 15 | 185 |
| 2003 | 200 | 50 | 150 |
| 2004 | 200 | 100 | 100 |
| 2005 | 200 | 400 | -200 |
| 2006 | 200 | 500 | -300 |
| 2007 | 200 | - | 200 |
| 2008 | 200 | - | 200 |
| 2009 | 200 | - | 200 |
| 2010 | 100 | - | 100 |
| 2011 | 100 | - | 100 |
| 2012 | 100 | - | 100 |
| 2013 | 100 | - | 100 |
| 2014 | 100 | - | 100 |
| 2215 | 100 | - | 100 |
| 2016 | 100 | - | 100 |
| 2017 | 100 | - | 100 |
| 2018 | 100 | - | 100 |
| 2019 | 100 | - | 100 |
As can be seen in Table T-10.10, the difference produces a negative NPV, which means that it should not be accepted. This means that is project 1 not superior to project 8.
See review questions Q-10E4.1 through Q-10E4.3.
| Previous: 3-Lives_different |
|
Next: 5-Comparison: |