IRR Function
Hello Everyone,
May i know if anyone have developed excel base IRR function or have any idea which return value on base of cashflows, safe in a table like as bellow (file attached):
IRR | 12.35% |
(15,450,900) | |
1 | 216,890.00 |
2 | 158,700.00 |
3 | 158,700.00 |
4 | 158,700.00 |
5 | 158,700.00 |
6 | 566,994.00 |
7 | 566,994.00 |
8 | 566,994.00 |
9 | 566,994.00 |
10 | 566,994.00 |
11 | 566,994.00 |
12 | 566,994.00 |
13 | 566,994.00 |
14 | 566,994.00 |
15 | 566,994.00 |
16 | 566,994.00 |
17 | 566,994.00 |
18 | 566,994.00 |
19 | 566,994.00 |
20 | 566,994.00 |
21 | 566,994.00 |
22 | 566,994.00 |
23 | 566,994.00 |
24 | 566,994.00 |
25 | 566,994.00 |
26 | 566,994.00 |
27 | 566,994.00 |
28 | 566,994.00 |
29 | 566,994.00 |
30 | 566,994.00 |
31 | 566,994.00 |
32 | 566,994.00 |
33 | 566,994.00 |
34 | 566,994.00 |
35 | 566,994.00 |
36 | 566,994.00 |
37 | 566,994.00 |
Tagged:
1