In: Finance
What is the modified internal rate of return for a 3-year project with the following characteristics?
Cash flow at time year 0 = -$100,000
Cash flow at time year 1 = $50,000
Cash flow at time year 2 = $50,000
Cash flow at time year 3 = $50,000
Corporate cost of capital = 10%
21% |
||
30% |
||
18% |
||
15% |
18%
Working;
Modified Internal rate of return | = | ((Future Value of positive cash flows/Present Value of negative Cash flows)^(1/Life))-1 | |||||||||||
= | ((165500/100000)^(1/3))-1 | ||||||||||||
= | 18% | ||||||||||||
Working: | |||||||||||||
Future Value of positive cash flows: | |||||||||||||
Year | Cash flows | Future Value of 1 | Future Value of cash flows | ||||||||||
a | b | c=1.10^(3-a) | d=b*c | ||||||||||
1 | $ 50,000 | 1.2100 | $ 60,500 | ||||||||||
2 | $ 50,000 | 1.1000 | $ 55,000 | ||||||||||
3 | $ 50,000 | 1.0000 | $ 50,000 | ||||||||||
Total | $ 1,65,500 | ||||||||||||