ES Tuesday 10-25-16 : Hot Topic

# Net Present Value NPV

Search Dictionary

## Definition of 'Net Present Value NPV'

Net Present Value is often abbreviated to its acronym NPV. It is a measure of the value of a dollar today compared to the same dollar in the future. In order to make this comparison we need to take into account inflation and any returns (such as interest) that may be realized by that dollar if it were to be invested.

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.

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.

Click link to access uploaded file:

NPV.xlsx

NPV.xlsx

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.

Emini Day Trading /
Daily Notes /
Forecast /
Economic Events /
Trading Indicators /
Search /
Terms and Conditions /
Disclaimer /
Books /
Online Books /
Site Map /
Contact /
Privacy Policy /
Links /
About /
Day Trading Forum /
Investment Calculators /
Pivot Point Calculator /
Market Profile Generator /
Fibonacci Calculator /
Mailing List /
Advertise Here /
Articles /
Financial Terms /
Brokers /
Software /
Holidays /
Stock Split Calendar /
Features /
Mortgage Calculator /
User Pages /
Donate

Copyright © 2004-2016, MyPivots. All rights reserved.

Copyright © 2004-2016, MyPivots. All rights reserved.