fill missing cells
(Not rated)
(Not rated)
| Flower Engineering is considering two mutually exclusive investments. The projects' expected net cash flows are as follows: | ||||||||||
| Expected Net Cash Flows | ||||||||||
| Time | Project A | Project B | ||||||||
| 0 | ($375) | ($575) | ||||||||
| 1 | ($300) | $200 | ||||||||
| 2 | ($200) | $200 | ||||||||
| 3 | ($100) | $200 | ||||||||
| 4 | $600 | $200 | ||||||||
| 5 | $600 | $200 | ||||||||
| 6 | $975 | $200 | ||||||||
| 7 | ($200) | $0 | ||||||||
| E) Regular Payback | ||||||||||
| Project A | ||||||||||
| Time period | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | ||
| Cash flow | (375) | (300) | (200) | (100) | 600 | $600 | $975 | ($200) | ||
| Cumulative cash flow | ??? | ??? | ??? | ??? | ??? | ??? | ??? | ??? | ||
| Payback | ??? | |||||||||
| Project B | ||||||||||
| Time period | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | ||
| Cash flow | (575) | 200 | 200 | 200 | 200 | $200 | $200 | $0 | ||
| Cumulative cash flow | ??? | ??? | ??? | ??? | ??? | ??? | ??? | ??? | ||
| Payback | ??? | |||||||||
10 years ago
fill missing cells A+ Tutorial use as Guide
NOT RATED
Purchase the answer to view it
- fill_missing_cells.xls