This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
en:how-to-calculate-the-npv-with-excel [2018/07/20 18:33] federico [- Insert the Excel NPV Formula] |
en:how-to-calculate-the-npv-with-excel [2018/08/10 10:53] (current) federico |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== How to Calculate NPV in Excel ====== | + | {{htmlmetatags> |
+ | metatag-description=(An easy way to calculate the Net Present Value in Excel [and formula]) | ||
+ | }} | ||
+ | |||
+ | ====== NPV in Excel ====== | ||
This pages teach you how to calculate the Net Present Value (NPV) of an investment project, using Microsoft Excel. | This pages teach you how to calculate the Net Present Value (NPV) of an investment project, using Microsoft Excel. | ||
Line 38: | Line 42: | ||
{{:en:npv-excel-3.png?nolink|}} | {{:en:npv-excel-3.png?nolink|}} | ||
- | ===== - Insert the Excel NPV Formula ===== | + | ===== 5- Insert the Excel NPV Formula ===== |
Click in a cell in which you want to calculate the NPV and: | Click in a cell in which you want to calculate the NPV and: | ||
Line 46: | Line 50: | ||
- close the formula, insert ")". If you press enter, you will have the present value of all future cash flows at period zero. | - close the formula, insert ")". If you press enter, you will have the present value of all future cash flows at period zero. | ||
- add the initial investment: at the end of the previous formula, in the same cell, insert "+" and select the cell containing the initial investment. (B3 in our example). Press enter and you will have calculated the NPV in Excel. | - add the initial investment: at the end of the previous formula, in the same cell, insert "+" and select the cell containing the initial investment. (B3 in our example). Press enter and you will have calculated the NPV in Excel. | ||
+ | |||
+ | {{:en:npv-excel-4.png?nolink|}} | ||
The final formula looks like this: | The final formula looks like this: | ||
Line 51: | Line 57: | ||
=NPV(E2,B4:B8)+B3 | =NPV(E2,B4:B8)+B3 | ||
- | {{:en:npv-excel-4.png?nolink|}} | + | |
{{:en:npv-excel-5.png?nolink|}} | {{:en:npv-excel-5.png?nolink|}} | ||