1 | Cash Flow Values | estimated_irr | |
---|---|---|---|
2 | -$20,000.00 | 0.51 | |
3 | -$1,000.00 | ||
4 | $9,000.00 | ||
5 | $15,000.00 | ||
6 | |||
7 | |||
8 | Result | Formula | |
9 | 0.05327950992 | =IRR(A2:A5) | |
10 | 0.05327950992 | =IRR(A2:A5,B2) | |
11 |
1 | Time | Cash Flow | Required Rate of Return | ||
---|---|---|---|---|---|
2 | 0 | -20000 | 15% | ||
3 | 1 | -1000 | |||
4 | 2 | 9000 | |||
5 | 3 | 12000 | |||
6 | 4 | 5100 | |||
7 | 5 | 4000 | |||
8 | 6 | 2000 | |||
9 | 7 | 800 | |||
10 | |||||
11 | |||||
12 | IRR | Formula | Decision | Formula | |
13 | 0.1481751488 | =IRR(B2:B9) | No | =IF(A13>D2, "Yes", "No") | |
14 | |||||
15 | NPV | Formula | Decision | Formula | |
16 | -104.0241051 | =NPV(D2,B3:B9) - (-B2) | No | =IF(A16>0, "Yes", "No") | |
17 |