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

NPV Calculator calculator

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 the NPV 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 (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

As taught in the CFA Institute curriculum, 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
  • 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.

How to Calculate NPV: Formula and Worked Example

NPV sums every future cash flow discounted to today, then subtracts the initial investment: NPV = Σ [Cash Flow_t ÷ (1 + r)^t] − Initial Investment.

For a $100,000 investment returning $30,000 a year for five years at a 10% discount rate, each year's cash flow is divided by 1.10 raised to that year's power, giving an NPV of about $13,724. A positive result means the project earns more than your 10% required return.

Choosing the Right Discount Rate (WACC and Hurdle Rate)

The discount rate represents your opportunity cost of capital and is the single most important NPV input.

  • Companies typically use their weighted average cost of capital (WACC), often 8–12%
  • real estate investors use 6–10%
  • venture investors much higher

Setting the rate too low overstates value and approves bad projects; too high rejects good ones. When unsure, calculate NPV across a range of rates rather than betting on a single number.

NPV vs IRR: When the Two Metrics Disagree

NPV and IRR usually agree on whether to accept a project, but they can conflict when ranking mutually exclusive projects of different sizes or cash-flow timing.

NPV measures absolute dollar value created and is the more reliable tie-breaker, while IRR expresses return as a percentage. When they disagree, finance theory says to follow NPV because it directly maximizes shareholder wealth.

Use our IRR calculator alongside this tool to see both perspectives.

Positive vs Negative NPV: The Decision Rule

The rule is simple: accept any independent project with a positive NPV and reject any with a negative NPV.

  • A positive NPV means the investment returns more than your required rate and adds wealth in today's dollars
  • a zero NPV means it exactly meets your hurdle rate

For competing projects you can only choose one of, pick the highest positive NPV.

NPV with Irregular and Uneven Cash Flows

Real investments rarely produce identical annual cash flows, and NPV handles this naturally because each period is discounted individually.

You can model a project that loses money in year one, breaks even in year two, and generates large inflows later — simply enter each year's actual cash flow.

This flexibility is why NPV is preferred for complex, lumpy investments where simpler metrics break down.

Profitability Index: NPV per Dollar Invested

The profitability index (PI) divides the present value of future cash flows by the initial investment, expressing efficiency as a ratio.

A PI above 1.0 corresponds to a positive NPV; a PI of 1.3 means each dollar invested returns $1.30 in present-value terms.

PI is especially useful for capital rationing — ranking projects when your budget can't fund every positive-NPV opportunity.

Payback Period vs Discounted Payback

Standard payback period counts how long until cumulative cash flows recover the investment, ignoring the time value of money.

Discounted payback first discounts each cash flow, then measures recovery time, giving a more conservative and realistic figure.

Both are useful liquidity and risk screens, but neither should replace NPV as the primary accept-or-reject metric.

NPV in Capital Budgeting and Project Selection

NPV is the backbone of corporate capital budgeting because it ranks competing projects by the actual dollar value each creates.

CFOs use it to choose between:

  • building a new plant
  • acquiring a competitor
  • buying back stock

Because NPV is additive, the combined NPV of selected projects equals the total value created — a property no percentage-based metric shares.

Sensitivity Analysis: NPV at Multiple Discount Rates

Because NPV is highly sensitive to the discount rate, serious analysis tests several rates rather than one.

The same $100,000 project that shows an NPV of $13,724 at 10% can turn negative near 13%, revealing how much margin for error you have.

Running NPV at low, base, and high discount rates exposes how robust an investment is before you commit capital.

Common NPV Mistakes to Avoid

Frequent NPV errors include:

  • using an arbitrary discount rate
  • forgetting to include terminal or salvage value
  • mixing nominal cash flows with a real discount rate
  • ignoring inflation or taxes

Another mistake is treating sunk costs as relevant — only future, incremental cash flows belong in an NPV. Clean inputs and a justified discount rate matter more than decimal precision.

Frequently Asked Questions

sell

Tags

verified

Data sourced from trusted institutions

All formulas verified against official standards.