Return on Investment (ROI) Template Prepared By Prepared on
Project # Project Name
Note: Cells C8:C14 and E8:E14 contain formulas to accumulate costs and benefits Cell C17 contains formula to calculate ROI Quarters 0 1 2 3 4 5 6 7 8 9 10 Costs ROI: Cumulative Costs Benefits Cumulative Benefits Payback?
-
#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 0 1.000 Quarter 1 0.985 0.985 Quarter 2 0.971 0.971 Quarter 3 0.956 0.956 Quarter 4 0.942 0.942 Quarter 5 0.928 0.928 Quarter 6 0.915 0.915 -
Benefits Discount PV of Benefits Costs Discount PV of Costs
1.000 -
Net Present Value:
The formula in cell C18 will calculate NPV when values are entered in cells B10:H11 and B14:H15
Quarter 7 0.901
Quarter 8 0.888
Quarter 9 0.875
Quarter Total 10 0.862 -
0.901
0.888
0.875
0.862 -
Quarter Costs 0 0 1 2 3
TOTAL Benefits (costs saved)
0
0
0
0
TOTAL
0
0
0
0
4
5
6
7
0
0
0
0
0
0
0
0