appliancewarehouse case study 11
kamishliang
form_19_npv-template.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
