Return on Investment (ROI) Template The formula in cell C17 will calculate ROI when
values are entered in cells B8:B14 and D8:D14
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 - -
1 - -
2 - -
3 - -
4 - -
5 - -
6 - -
- -
ROI: #DIV/0!