appliancewarehouse case study 9
kamishliang
form_18_roi-template.xlsROI Template
| Return on Investment (ROI) Template | ||||
| Note: Cells C8:C14 and E8:E14 contain formulas to accumulate costs and benefits | ||||
| Cell C17 contains formula to calculate ROI | ||||
| Year | Costs | Cumulative | Benefits | Cumulative |
| Costs | Benefits | |||
| 0 | - 0 | - 0 | ||
| 1 | - 0 | - 0 | ||
| 2 | - 0 | - 0 | ||
| 3 | - 0 | - 0 | ||
| 4 | - 0 | - 0 | ||
| 5 | - 0 | - 0 | ||
| 6 | - 0 | - 0 | ||
| - 0 | - 0 | |||
| ROI: | 0.0% |
The formula in cell C17 will calculate ROI when values are entered in cells B8:B14 and D8:D14
