Tuesday, May 19, 2015

Ranking projects by IRR

YearProject AProject BDiscount Factor
@ 18%
Present Value - APresent Value - B
0-500-5001-500.00-500.00
11672000.8475141.53169.50
21802500.7182129.28179.55
31601700.608697.38103.46
4100250.515851.5812.90
5100300.437143.7113.11
    -36.53-21.48


Internal rate of return  = small % + (large % - small %) [positive NPV/(positive NPV - negative NPV)]

IRR - A = 12% + (18% - 12%) [26.79/ 26.79+36.53]
            = 12% + (6%) (26.79/63.32)
            = 0.1454

IRR - B = 12% + (18% - 12%) [31.80/ 31.80 + 21.48]
            = 12% + (6%) [31.80/ 53.28]
            = 0.1566

Project B will be preferred as it has a higher IRR compared to Project A.
However, both projects are desirable as they both have IRR higher than the cost of capital of 12%.

No comments:

Post a Comment