homework
boywkuts3x60
10ROIAnalysis.xlsNPV Template
| Net Present Value (NPV) Template | ||||||||
| 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) | ||||||||
| Year | Year | Year | Year | Year | Year | Year | Total | |
| 0 | 1 | 2 | 3 | 4 | 5 | 6 | ||
| Benefits | ||||||||
| Factor | ||||||||
| PV of Benefits | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| Costs | ||||||||
| Factor | ||||||||
| PV of Costs | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| Net Present Value: | - 0 |
The formula in cell C18 will calculate NPV when values are entered in cells B10:H11 and B14:H15
ROI Template
| 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 | Costs | Cumulative | Benefits | Cumulative |
| Costs | Benefits | |||
| 0 | - 0 | - 0 | ||
| 1 | - 0 | - 0 | ||
| 2 | - 0 | - 0 | ||
| 3 | - 0 | - 0 | ||
| 4 | - 0 | - 0 | ||
| 5 | - 0 | - 0 | ||
| 6 | - 0 | - 0 | ||
| - 0 | - 0 | |||
| ROI: | 0.0% |
The formula in cell C17 will calculate ROI when values are entered in cells B8:B14 and D8:D14
Payback Analysis Template
| Payback Analysis Template | ||||
| Note: Cells C8:C14 and E8:E14 contain formulas to accumulate costs and benefits | ||||
| Year | Costs | Cumulative | Benefits | Cumulative |
| Costs | Benefits | |||
| 0 | - 0 | - 0 | ||
| 1 | - 0 | - 0 | ||
| 2 | - 0 | - 0 | ||
| 3 | - 0 | - 0 | ||
| 4 | - 0 | - 0 | ||
| 5 | - 0 | - 0 | ||
| 6 | - 0 | - 0 |
