1 | discount rate | cash flow | |
---|---|---|---|
2 | 8% | -7500 | |
3 | 3000 | ||
4 | 5000 | ||
5 | 1200 | ||
6 | 4000 | ||
7 | |||
8 | |||
9 | Result | Formula | |
10 | 3457.18998 | =NPV(A2,B3:B6)+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 |