# net present value

Also found in: Dictionary, Acronyms, Encyclopedia, Wikipedia.

## Net present value (NPV)

## Net Present Value

## net present value

## net present value

see INVESTMENT APPRAISAL, DISCOUNTED CASH FLOW.## net present value

see DISCOUNTED CASH FLOW.## net present value

An analytical tool for evaluating whether or not to purchase an investment. The tool does not tell you if an investment is good or bad;it tells you if the investment will meet your predetermined objectives or not.

• Critical to defining your objectives is setting the equivalent of an interest rate you would like to earn on your initial cash investment. This is called the discount rate. The discount rate may change from investment to investment, depending on your assessment of the risk. The safest investment is an FDIC-insured savings account, but it returns the lowest interest rate. You, the investor, decide what rate you would like to earn. You use the net-present-value tool to calculate whether a particular investment will earn the rate you want.

• Having said all that, the official definition of net present value is as follows: using a preselected discount rate, net present value is the present value of all cash incomes, less the present value of all cash outflows (including initial investment). If this is not clear, it will become so with the example below.

• If the net present value is 0 or a positive number, the investor should go forward. If the answer is negative for the discount rate selected, then the investment should not be made because it will not meet the investor's objectives, not because it is a “bad investment” in the ordinary sense of that phrase.

• The Excel formula for present value is pv (rate, cashflow, cashflow, cashflow)

‘'Rate” is the cell with the interest rate the investor would like to earn. Each of the “cashflow” entries is a cell address for cash flows by the end of each year, such as year 1, year 2, year 3, and so on. If an asset is sold in a particular year, the net sales price (after expenses of the sale) is entered as part of the cash flow for that year. One flaw of the system is that it assumes all cash flows are received at year-end, when they are really received over time, but that is usually a relatively minor problem.