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 100 100 150 150
1 100 150
2 100 150
3 100 150
4 100 150
5 100 150
6 100 150
100 150
ROI: 50.0%