NPV Calculator

Net Present Value (NPV) is the gold standard of capital budgeting. It tells you whether the future cash flows of an investment, discounted back to today's dollars at your required rate of return, exceed the initial cost. A positive NPV means the project creates value and should be accepted; a negative NPV means it destroys value and should be rejected. Our NPV calculator handles any number of irregular cash flows, computes the profitability index, payback period (both undiscounted and discounted), and displays a year-by-year breakdown showing how each future cash flow translates into present value.

star 4.9
auto_awesome AI
New

tune Project Inputs

Upfront cost (cash outflow at year 0)

10%
0% 20% 40%

analytics Results

Net Present Value
$48,033
Accept
Total Discounted PV
$148,033
Sum of CFs
$200,000
Profitability Index
1.4803
# of Periods
5
Payback (Undisc)
2.88 yrs
Discounted Payback
3.45 yrs
Year-by-Year PV
Yr CF PV

tips_and_updates Tips

  • Positive NPV → accept the project; negative NPV → reject; zero → indifferent
  • Use your weighted average cost of capital (WACC) as the discount rate for company projects
  • For personal investments, use your required rate of return or opportunity cost
  • When comparing mutually exclusive projects, pick the one with the highest NPV (not highest IRR)
  • Profitability index > 1 means NPV is positive — useful for ranking when capital is constrained
  • Discounted payback is longer than undiscounted payback because future dollars are worth less
  • NPV is sensitive to the discount rate — try multiple rates to see how robust the decision is

How to Use This Calculator

1

Enter initial investment

The upfront cost of the project (cash outflow at time 0).

2

Set discount rate

Your required rate of return — WACC for companies, opportunity cost for individuals.

3

Enter yearly cash flows

Comma-separated list of expected cash inflows for each year (year 1, year 2, ...).

4

Read NPV

See the net present value, decision (Accept/Reject), profitability index, and payback periods.

5

Try different discount rates

NPV is sensitive to the discount rate — try a few scenarios to test how robust your decision is.

The Formula

Each future cash flow is divided by (1+r)^t to convert it to present value — a dollar received in year 5 is worth less than a dollar today because of the time value of money and the opportunity cost of tying up capital. The sum of all present values minus the initial investment is the NPV. If NPV > 0, the project earns more than your discount rate; if NPV < 0, it earns less.

NPV = -Initial + Σ CF_t / (1 + r)^t for t = 1..n

lightbulb Variables Explained

  • NPV Net present value (positive = create value)
  • Initial Initial investment (cash outflow at t=0)
  • CF_t Cash flow in period t
  • r Discount rate (cost of capital, decimal)
  • t Period number (1, 2, 3, ..., n)
  • n Number of periods

tips_and_updates Pro Tips

1

Positive NPV → accept the project; negative NPV → reject; zero → indifferent

2

Use your weighted average cost of capital (WACC) as the discount rate for company projects

3

For personal investments, use your required rate of return or opportunity cost

4

When comparing mutually exclusive projects, pick the one with the highest NPV (not highest IRR)

5

Profitability index > 1 means NPV is positive — useful for ranking when capital is constrained

6

Discounted payback is longer than undiscounted payback because future dollars are worth less

7

NPV is sensitive to the discount rate — try multiple rates to see how robust the decision is

NPV directly measures the dollar value an investment creates — not a percentage, not a payback time, but actual currency value added. It correctly handles any cash flow pattern, properly discounts future dollars to today's value, and gives an unambiguous accept/reject signal. Other metrics like IRR, ROI, or payback period have important roles, but they all have edge cases where they mislead. NPV doesn't. It's the metric every MBA finance class teaches first and every CFO uses last.

The biggest decision you'll make in NPV analysis isn't the cash flow estimates — it's the discount rate. A small change in rate (10% → 12%) can flip a positive NPV to negative. Always document your discount rate assumption and run sensitivity analysis with at least three rates: optimistic (low), base case, and pessimistic (high). If NPV stays positive across all three, the project is robust. If it flips, you need better cash flow estimates or a different project.

Frequently Asked Questions

sell

Tags

verified

Data sourced from trusted institutions

All formulas verified against official standards.