In: Finance
Project B has the following Cash Flows: Cost = $800,000; Year 1 = $329,000; Year 2 = $260,750; Year 3 = $192,500; Year 4 = $147,000; Year 5 = $101,500. Calculate the Internal Rate of Return for Project B.
Ans 11.36%
Year | Project Cash Flows (i) | DF@ 10% | DF@ 10% (ii) | PV of Project ( (i) * (ii) ) | DF@ 20% (iii) | PV of Project ( (i) * (iii) ) |
0 | -800000 | 1 | 1 | (8,00,000) | 1 | (8,00,000) |
1 | 329000 | 1/((1+10%)^1) | 0.909091 | 2,99,091 | 0.833 | 2,74,167 |
2 | 260750 | 1/((1+10%)^2) | 0.826446 | 2,15,496 | 0.694 | 1,81,076 |
3 | 192500 | 1/((1+10%)^3) | 0.751315 | 1,44,628 | 0.579 | 1,11,400 |
4 | 147000 | 1/((1+10%)^4) | 0.683013 | 1,00,403 | 0.482 | 70,891 |
5 | 101500 | 1/((1+10%)^5) | 0.620921 | 63,024 | 0.402 | 40,791 |
NPV | 22,641 | NPV | (1,21,675) | |||
IRR = | Ra + NPVa / (NPVa - NPVb) * (Rb - Ra) | |||||
10% + 22641 / (22641 + 121675)*10% | ||||||
11.36% | ||||||