This, one sheet Excel workbook will let you understand and help you make an NPV model in Excel. It takes "Equipment" as an example to demonstrate NPV model, however this can be changed as per your needs.

This Template is accompanied by a PDF document which will help you undertand and implement NPV and IRR calculations in Excel.

After studying the document you will be able to
* Explain the concept of Time Value of Money
* Calculate the present value and future value of a stream of cash flows using excel
* Explain the types of cash flows encountered in financial analysis, and how to adjust for each type in making time value calculations in Excel.
* Differentiate between the alternative compounding periods, and use Excel to compare present and future values under different compounding schemes.

The template is unprotected, to make sure you can make appropriate changes.

The workbook and the document comes with a nominal cost of $15 and will work with Microsoft Excel Version 2002 onwards and any PDF reader.

Click the button below to download NPV Caculator...