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

Net Present Value: The Foundation of Investment Analysis

Net present value (NPV) answers the most fundamental question in finance: does this investment create or destroy wealth? By discounting all future cash flows back to their present-day value using a required rate of return, then subtracting the initial investment, NPV produces a single dollar figure that represents the value created. A positive NPV means the investment returns more than your minimum required rate; a negative NPV means it falls short. Unlike simpler metrics such as payback period (which ignores cash flows after the breakeven point) or ROI (which ignores the time value of money), NPV captures both the magnitude and timing of every cash flow. The discount rate is the critical input — it represents your opportunity cost of capital, typically 8-12% for corporate investments and 6-10% for real estate. A $100,000 investment returning $30,000 annually for 5 years has an NPV of $13,724 at a 10% discount rate, but drops to negative $1,862 at 13%. This sensitivity is why serious financial analysis always includes NPV calculations at multiple discount rates. NPV is used universally in capital budgeting, M&A valuation, project selection, and any decision where cash flows occur over time.

Why NPV is the gold standard

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.

NPV and the discount rate

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.