15 NPV Template - Year Year Year Year Year Year Total 1 2 3...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
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
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Year Year Year Year Year Year Total 1 2 3 4 5 6 Benefits Factor PV of Benefits- - - - - - - - Costs Factor 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...
View Full Document

This note was uploaded on 10/05/2011 for the course ECON 2301 taught by Professor Econmaster during the Spring '11 term at Dallas Colleges.

Ask a homework question - tutors are online