Example: An Investment with Grouped Cash Flows. You are considering an investment that requires a cash outlay of $9,000, with the promise of monthly cash flows as shown. Calculate IRR%. Also find NPV and NFV at an annual interest rate of 9%.
|
|
| 10, | 10, | 10, | 10, | 150, 0 | 1,50 0 | 1,50 0 |
50 | 50 | 50 | 00 | 00 | 00 | 00 |
|
|
|
0 | 0 | 0 |
|
|
|
|
|
|
|
0
$ _ 9,000
Since some of these cash flows are grouped (consecutive and equal), the #TIMES prompting must be on so you can specify a number other than 1.
Group Number | Amount | Number of Times |
|
|
|
Initial | -9,000 | - |
1 | 500 | 3 |
2 | 1,000 | 4 |
3 | 0 | 1 |
4 | 1,500 | 3 |
|
|
|
Keys: | Display: | Description: | |
|
| Current | |
|
| | |
|
| CFLO menu. | |
|
|
| |
@c | | Clears current list. #TIMES | |
|
| prompting is turned on. | |
|
| | |
9000 &I | Stores the initial cash | ||
|
|
| flow. |
104 7: Cash Flow Calculations
File name :