Net Present Value NPV
Definition of 'Net Present Value NPV'
The easiest way to calculate the NPV is to use a spreadsheet such as Microsoft Excel which has a formula called =NPV() which will do the calculation for you.
The following image is from an example done in Excel 2007. The excel spreadsheet that was used can be downloaded below.
In the example above we are calculating the present day value of buying a business that will generate a cash flow of $1,000 for each of the next 6 years. Our assumed interest rate is 4.5%. Using the Net Present Value formula in Excel shown in cell B6 we can see that the NPV of the business is $5,157.87 even though it will generate $6,000 over the life of the business.
If our estimate of inflation of 4.5% over the next 6 years is accurate then we should not pay more than the NPV for the business. If the owner were to sell it to us at any price below $5,157.87 then it would be worth buying.
Do you have a trading or investing definition for our dictionary? Click the Create Definition link to add your own definition. You will earn 150 bonus reputation points for each definition that is accepted.
Is this definition wrong? Let us know by posting to the forum and we will correct it.