Boneyard Tools

Net Present Value (NPV) Calculator

Find the net present value of a project or investment. Enter your discount rate and the cash flow for each period, starting with the initial outlay, to see the value created in today's money.

How to calculate net present value

  1. Enter the annual discount rate as a percent.
  2. List each period's cash flow, starting with the initial outlay at time zero (usually negative).
  3. Read the NPV. A positive number means the investment adds value at that rate.

Examples

10% discount rate on -1000, 300, 400, 500

rate 10%, cash flows -1000, 300, 400, 500
NPV -21.04

Frequently asked questions

What is net present value?

Net present value is the sum of every future cash flow discounted back to today, minus the initial outlay. It tells you how much value an investment creates in today's money at a chosen discount rate.

What is the NPV formula?

NPV is the sum over each period t of cash flow divided by (1 + r) to the power t, where r is the discount rate as a decimal. The cash flow at time zero is added at full value because no discounting applies yet.

Should the first cash flow be negative?

Usually yes. The cash flow at time zero is the initial investment or outlay, so it is entered as a negative number. Later inflows are positive and earlier outflows are negative.

What does a positive NPV mean?

A positive NPV means the investment is expected to earn more than your discount rate, so it adds value. A negative NPV means it falls short of that required return at the rate you entered.

How do I pick a discount rate?

The discount rate usually reflects your required return or cost of capital. A higher rate discounts future cash flows more heavily and lowers the NPV, while a lower rate raises it.

Related tools