Page 109 - BOSC-P Vodafone Apr 2017
P. 109
Internal Rate Of Return
Cost of Capital or Hurdle
Rate
10%
10% NPV
Year Cash Flow NPV Values
Factors
0 (50,000) 1.000 (50,000)
1 50,000 0.909091 45,455
2 50,000 0.826446 41,322
3 50,000 0.751315 37,566
4 50,000 0.683013 34,151
5 50,000 0.620921 31,046
Sum 139,539
IRR 96.59
Excel function: IRR(-50K, 50K, 50K, 50K, 50K, 50K) = 96.59%
