ROI Template

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!