In: Finance
A company is analyzing two mutually exclusive projects, P and D, with the following cash flows:
0 1 2 3 4
Project P -$1,000 $872.56 $250 $10 $10
Project D -$1,000 $0 $260 $380 $863.80
The company's WACC is 9.0%. What is the IRR of the better project? (Hint: The better project may or may not be the one with the higher IRR.) Round your answer to two decimal places.
| Project P | |||
| Statement Computing NPV | in $ | ||
| Year | Cash Inflows | Discount factor 9% | Discounted Value |
| 0 | -1000.00 | 1.000 | -1000.00 |
| 1 | 872.56 | 0.917 | 800.51 |
| 2 | 250.00 | 0.842 | 210.42 |
| 3 | 10.00 | 0.772 | 7.72 |
| 4 | 10.00 | 0.708 | 7.08 |
| NPV | 25.74 |
| Project D | |||
| Statement Computing NPV | in $ | ||
| Year | Cash Inflows | Discount factor 9% | Discounted Value |
| 0 | -1000.00 | 1.000 | -1000.00 |
| 1 | 0.00 | 0.917 | 0.00 |
| 2 | 260.00 | 0.842 | 218.84 |
| 3 | 380.00 | 0.772 | 293.43 |
| 4 | 863.80 | 0.708 | 611.94 |
| NPV | 124.20 |
| Since NPV of Project D is Higher hence Project D is the Better Project |
| IRR Of Project D | |||||
| Discounting The Flows with 15% Rate | |||||
| Year | Cash Inflows | Discount factor 9% | Discount factor 15% | Discounted Value 9% | Discounted Value 15% |
| 0 | -1000.00 | 1.000 | 1.000 | -1000.00 | -1000.00 |
| 1 | 0.00 | 0.917 | 0.870 | 0.00 | 0.00 |
| 2 | 260.00 | 0.842 | 0.756 | 218.84 | 196.60 |
| 3 | 380.00 | 0.772 | 0.658 | 293.43 | 249.86 |
| 4 | 863.80 | 0.708 | 0.572 | 611.94 | 493.88 |
| NPV | 124.20 | -59.67 | |||
| Difference in NPV | 183.87 | ||||
| IRR = 9% + 6%*124.20/183.87 | |||||
| IRR = 13.053% |