Return on Investment (ROI) Template
Prepared By Project #
Prepared on Project Name
Note: Cells C8:C14 and E8:E14 contain formulas to accumulate costs and benefits
Cell C17 contains formula to calculate ROI
Quarters Costs Cumulative Benefits Cumulative Payback?
Costs Benefits
0 - - -
1 - - - -
2 - - - -
3 - - - -
4 - - - -
5 - - - -
6 - - - -
7 - - - -
8 - -
9 - -
10 - -
- -
ROI: #DIV/0!
Net Present Value (NPV) Template
Prepared By Project #
Prepared on Project Name
Quarterly RATE: 1.5%
Note:
Cells B12:H12 and B16:H16 contain formulas to multiply discount factors * benefit and cost values
Cells I12 and I16 contain adjusted cost and benefit totals
Cell C18 contains the calculation for net present value (NPV)
Quarter Quarter Quarter Quarter Quarter Quarter Quarter
0 1 2 3 4 5 6
Benefits - - - - - - -
Discount 1.000 0.985 0.971 0.956 0.942 0.928 0.915
PV of Benefits - - - - - - -
Costs - - - - - -
Discount 1.000 0.985 0.971 0.956 0.942 0.928 0.915
PV of Costs - - - - - - -
Net Present Value: -
The formula in cell C18 will calculate NPV when values are
entered in cells B10:H11 and B14:H15
Quarter Quarter Quarter Quarter Total
7 8 9 10
- - - -
0.901 0.888 0.875 0.862
-
- - - -
0.901 0.888 0.875 0.862
-
Quarter
Costs 0 1 2 3
0
TOTAL 0 0 0 0
Benefits (costs saved)
TOTAL 0 0 0 0
4 5 6 7
0 0 0 0
0 0 0 0