Question: use xirr to compute the internal rate of return for...
Question details
Use XIRR to compute the internal rate of return for the following investment (please provide excel work and functions):
A | B | |
1 | Date | Cash flow |
2 | 30-Jun-07 | -799 |
3 | 14-Feb-08 | 70 |
4 | 14-Feb-09 | 70 |
5 | 14-Feb-10 | 70 |
6 | 14-Feb-11 | 70 |
7 | 14-Feb-12 | 70 |
8 | 14-Feb-13 | 1,020 |