Net Present Value (NPV) Calculator

Calculate net present value of future cash flows. Enter up to 20 periods with a discount rate to evaluate any investment or project decision.

About the Net Present Value (NPV) Calculator

Net present value (NPV) is the gold standard for evaluating investment decisions. It takes all expected future cash flows — both inflows and outflows — discounts them to the present at an appropriate rate, and subtracts the initial investment. A positive NPV means the investment creates value; a negative NPV means it destroys value.

This calculator supports up to 20 cash flow periods with custom amounts for each. Enter your initial investment (as a negative cash flow), the expected cash flows for each period, and the discount rate. The tool computes the NPV, cumulative discounted cash flows, and shows which period achieves payback.

NPV is used by corporations for capital budgeting, by investors for valuing businesses, and by individuals for comparing financial options like rent-vs-buy, lease-vs-purchase, and education investment decisions. By translating all future amounts into their present-day equivalents, NPV reveals whether a project generates more value than it costs, accounting for the time value of money.

Why Use This Net Present Value (NPV) Calculator?

Unlike simpler metrics like payback period or ROI, NPV accounts for the time value of money and evaluates the entire stream of cash flows. It gives you a single dollar figure that represents the value an investment adds or destroys, making it the most theoretically sound decision tool in finance.

How to Use This Calculator

  1. Enter the initial investment amount (this is your upfront cost).
  2. Enter the annual discount rate.
  3. Add cash flows for each period — positive for inflows, negative for outflows.
  4. Use the + button to add more periods or the x button to remove them.
  5. View the NPV, total undiscounted cash flows, and payback period.
  6. A positive NPV means the investment is worth pursuing at the given discount rate.

Formula

NPV = -Initial Investment + Sum of [CF_t / (1 + r)^t] for t = 1 to n, where CF_t is the cash flow in period t and r is the discount rate.

Example Calculation

Result: NPV: $7,071

An initial investment of $50,000 followed by four years of positive cash flows ($15K, $18K, $20K, $22K) at a 10% discount rate yields an NPV of $7,071. Since NPV is positive, this investment creates value and should be accepted. The discounted payback occurs during year 3.

Tips & Best Practices

NPV in Corporate Capital Budgeting

Public companies use NPV as the primary tool for capital allocation decisions. When evaluating whether to build a new factory, launch a product, or acquire a competitor, finance teams estimate future cash flows, discount them at the company WACC, and accept projects with positive NPV. This disciplined approach maximizes shareholder value systematically.

NPV vs IRR — When They Disagree

For independent projects (accept/reject decisions), NPV and IRR always agree: positive NPV corresponds to IRR above the discount rate. But for mutually exclusive projects, they can rank differently. NPV is the superior criterion because it correctly accounts for project scale and reinvestment assumptions.

Sensitivity Analysis Is Essential

A single NPV number is less useful than a range. Test your NPV at multiple discount rates (base case +/- 2%), with optimistic and pessimistic cash flow estimates, and over different time horizons. This reveals how sensitive the decision is to your assumptions and highlights the key risk drivers.

Frequently Asked Questions

What does a positive NPV mean?

A positive NPV means the investment is expected to generate returns above the discount rate, creating value for the investor. The NPV figure represents the dollar amount of value created in today's terms.

What discount rate should I use for NPV?

For corporate projects, use the weighted average cost of capital (WACC). For personal investments, use your expected alternative return rate (opportunity cost). For very safe investments, the risk-free rate. For risky ventures, add a risk premium.

What is the difference between NPV and IRR?

NPV gives you a dollar amount of value created at a specific discount rate. IRR gives you the rate at which NPV equals zero. Both are useful — NPV is better for comparing projects of different sizes; IRR is better for understanding the return rate.

Can NPV be negative?

Yes. A negative NPV means the investment is expected to destroy value at the given discount rate — the present value of future cash flows does not justify the upfront cost. Avoid investments with negative NPV unless there are strategic non-financial benefits.

How does NPV handle uneven cash flows?

NPV naturally handles uneven cash flows — each period cash flow is discounted independently. This is one of its advantages over metrics like payback period that treat all cash flows equally.

What are the limitations of NPV?

NPV depends heavily on the discount rate and cash flow estimates, both of which involve uncertainty. It does not capture strategic options (flexibility to expand or abandon), and it assumes cash flows are known with certainty. Always perform sensitivity analysis.

Related Pages