In: Finance
A firm evaluates all of its projects by applying the IRR rule. If the required return is 14 percent, should the firm accept the following project?
Year Cash Flow
0 -$30,000
1 16,000
2 20,000
3 15,000
IRR is that discount rate for which NPV = 0. It has to be found out by trial and error, by varying the discount rate till 0 NPV is reached. | ||||||||||
The trial and error can be done as given in table below: | ||||||||||
YEAR | CASH FLOW | PVIF at 14% | PV at 14% | PVIF at 30% | PV at 30% | PVIF at 33% | PV at 33% | PVIF at 32% | PV at 32% | |
0 | $ -30,000 | 1.00000 | $ -30,000 | 1 | $ (30,000) | 1 | $ (30,000) | 1 | $ (30,000) | |
1 | $ 16,000 | 0.87719 | $ 14,035 | 0.76923 | $ 12,308 | 0.75188 | $ 12,030 | 0.75758 | $ 12,121 | |
2 | $ 20,000 | 0.76947 | $ 15,389 | 0.59172 | $ 11,834 | 0.56532 | $ 11,306 | 0.57392 | $ 11,478 | |
3 | $ 15,000 | 0.67497 | $ 10,125 | 0.45517 | $ 6,827 | 0.42505 | $ 6,376 | 0.43479 | $ 6,522 | |
NPV | $ 9,549 | $ 970 | $ (288) | $ 121 | ||||||
It can be seen that the WACC of 14% gives positive NPV. Hence, to reduce the NPV, the discount rate has to be increased. | ||||||||||
Trials with 30%, 32% and 33% gives NPV with small variations. NPV is negative at 33% and positive at 32%. It means that the discount rate for 0 NPV [IRR] lies between 32% and 33% | ||||||||||
By simple interpolation IRR = 32%+1%*121/(121+288) = | 32.30% | |||||||||
DECISION: | ||||||||||
The IRR of the project is 32.30%. | ||||||||||
The decision rule with IRR is that, all projects with IRR>WACC can be accepted. | ||||||||||
Hence, the project can be accepted. |