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 0 1 2 3 4 5 6 Costs 100 Cumulative Costs 100 100 100 100 100 100 100 Benefits 150
The formula in cell C17 will calculate ROI when values are entered in cells B8:B14 and D8:D14
Cumulative Benefits 150 150 150 150 150 150 150
100 ROI: 50.0%
150