NPV guide

How to calculate NPV

Net present value is calculated by discounting each future cash flow back to today and then adding the discounted values together. The initial investment is usually entered as a negative cash flow at year 0.

Open the NPV calculator

Step-by-step NPV calculation

  1. List each annual cash flow, including the initial investment.
  2. Choose the discount rate that reflects the required return or cost of capital.
  3. Discount each future cash flow using Cash flow / (1 + r)t.
  4. Add all discounted values together to calculate NPV.
  5. Compare the result with zero or with alternative investment scenarios.

Interpreting the result

A positive NPV means the modelled cash flows are worth more than the initial investment at the selected discount rate. A negative NPV means the investment does not reach the selected required return based on the inputs.