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 0 1 2 3 4 5 6
Costs
Cumulative Costs ROI: #DIV/0!
Benefits
Cumulative Benefits -
-