NPV Calculator

The NPV formula

Net Present Value (NPV) measures whether a project or investment creates value once every future cash flow is converted back into today's dollars — a direct way of answering "is this actually worth doing, given what my money could otherwise earn?"

Worked example: a $100,000 initial investment with cash flows of $25,000, $30,000, $35,000, $40,000, and $45,000 over the following five years, discounted at a 10% rate, produces an NPV of roughly $29,079 — a positive result, meaning the project is projected to create about $29,000 more value than simply earning the 10% required return elsewhere.

This same worked example also illustrates why NPV and simple total-cash-flow addition give meaningfully different answers. Adding up the raw cash flows ($25,000 + $30,000 + $35,000 + $40,000 + $45,000 = $175,000) against the $100,000 investment would suggest a $75,000 total profit — considerably more optimistic than the properly discounted $29,079 NPV. The gap between these two figures is entirely the effect of discounting, which appropriately reduces the value of cash flows that arrive further in the future rather than treating every dollar as equally valuable regardless of timing.

Each future cash flow is discounted by a different amount depending on how far in the future it arrives. A dollar received next year is discounted less than a dollar received in year five, since money further in the future is worth less in today’s terms — this is the core insight behind the “time value of money” that NPV is specifically designed to capture, unlike a simple sum of raw cash flows that ignores timing entirely.

A cumulative NPV table — showing the running total after each year’s cash flow is added — is a useful way to see exactly when a project crosses from net-negative to net-positive. This running total starts at negative the full initial investment and climbs each year as discounted cash flows are added, crossing zero at whatever point the project has generated enough discounted value to fully offset its upfront cost. Watching this progression year by year gives a more complete picture than the single final NPV figure alone.

Choosing a discount rate

The discount rate represents the required rate of return or opportunity cost of capital — essentially, what the money could otherwise earn if not tied up in this specific project. Businesses commonly use their Weighted Average Cost of Capital (WACC), typically in the 8-12% range for established companies, while individual investors might use an expected market return (commonly 7-10%).

WACC itself is calculated as a blend of a company’s cost of debt and cost of equity, weighted by how much of each makes up the company’s overall capital structure. A company financed heavily through debt will have a different WACC than one financed primarily through equity, even with otherwise similar operations — this is precisely why WACC is specific to each individual company’s actual financing mix rather than being a single universal figure applicable across all businesses.

Choosing the right discount rate matters enormously, since NPV is highly sensitive to this single input. A project that looks attractive at an 8% discount rate can look unattractive at 12%, even though nothing about the underlying cash flows has changed — only the assumed opportunity cost has shifted. When genuinely uncertain which rate to use, testing the calculation at a few different plausible rates (rather than committing to a single assumption) reveals how sensitive the conclusion actually is to that choice.

A conservative default of around 10% is a reasonable starting point for someone without a more specific, personalized rate to use, since it roughly approximates a typical long-run equity market return and represents a genuine opportunity cost for capital that could otherwise be invested passively. This isn’t a universally correct rate for every situation, but it’s a defensible, commonly used baseline when a more precise figure (like an actual computed WACC) isn’t readily available.

NPV vs. IRR

IRR (Internal Rate of Return) is the discount rate at which NPV exactly equals zero — the break-even rate of return a project would need to deliver to be exactly worth doing, no more and no less. If a project’s actual IRR exceeds the required discount rate, the project is generally worth pursuing; if it falls short, it generally isn’t.

NPV and IRR typically agree on whether to accept or reject a single project, but NPV is the more reliable metric when comparing multiple competing projects of different sizes or durations. IRR can sometimes rank projects in a misleading order — a smaller project with a very high IRR might create less total value than a larger project with a more modest IRR, simply because the larger project generates more absolute dollars of value even at a lower percentage return. NPV, expressed in dollar terms rather than a percentage, avoids this particular pitfall when comparing projects of meaningfully different scale.

Finding the exact IRR generally requires an iterative numerical approach, since the equation for IRR — solving for the rate that makes a specific sum of discounted cash flows equal zero — doesn’t have a simple direct algebraic solution for most realistic cash flow patterns. Bisection (progressively narrowing a bracketed range known to contain the answer) is a reliable, straightforward method for this, converging on an accurate estimate through repeated refinement rather than requiring a closed-form formula.

Interpreting positive and negative NPV

A negative NPV doesn’t necessarily mean a project is a bad idea in every sense — it specifically means the project doesn’t clear the bar of the assumed discount rate. A project with strategic value beyond pure cash flow (entering a new market, building a capability for future use) might still be worth pursuing despite a negative NPV under a purely financial lens, provided that non-financial value is explicitly acknowledged as a separate consideration rather than assumed away.

A zero NPV result carries a specific, useful meaning of its own, even though it’s a less common outcome in practice than a clearly positive or negative result. It means the project’s return exactly equals the discount rate — the project neither creates nor destroys value relative to the alternative use of that capital, making it a genuinely neutral decision from a purely financial standpoint, where other qualitative factors would reasonably become the deciding consideration.

Real-world applications

Evaluating whether to invest in new equipment, a facility expansion, or a major capital project is the classic corporate finance application of NPV — comparing the upfront cost against the discounted value of the future cash flows that investment is expected to generate.

Comparing multiple competing investment opportunities with a limited capital budget benefits from ranking projects by NPV rather than by IRR or raw cash flow totals alone, since NPV directly reflects the actual dollar value each project is expected to create after accounting for the required rate of return.

Deciding between two different project structures with different cash flow timing — a project with fast early returns versus one with a larger payoff further in the future — benefits from NPV’s built-in time-value-of-money adjustment, since a simple undiscounted total would treat both timing patterns as equivalent when they genuinely aren’t.

Evaluating a business acquisition or a long-term contract benefits from modeling the full expected cash flow stream over the relevant time horizon and discounting it back to a single present-day figure — this makes it possible to compare an acquisition’s asking price directly against the discounted value of what it’s actually expected to generate, rather than relying on simpler but less rigorous valuation shortcuts.

Deciding whether to pursue a project with a longer payback period but a larger eventual payoff benefits from NPV specifically because it weighs the full cash flow stream rather than just how quickly the initial investment is recovered — a project that takes longer to break even but generates substantially more value overall can still show a higher NPV than a faster-payback alternative with more modest total returns, a distinction that a simple payback-period analysis alone would miss entirely.

Common mistakes to avoid

• Using an inappropriate discount rate for the situation. A rate that’s too low overstates a project’s attractiveness; a rate that’s too high understates it — using a rate genuinely reflective of the actual opportunity cost or required return is essential for a meaningful result.
• Ranking competing projects by IRR instead of NPV when comparing different-sized opportunities. IRR can favor a smaller, high-percentage-return project over a larger project that actually creates more total value — NPV avoids this specific pitfall.
• Treating a negative NPV as an automatic, absolute rejection regardless of context. Strategic or non-financial value beyond the pure cash-flow analysis is a legitimate separate consideration, though it should be acknowledged explicitly rather than used to quietly override an unfavorable financial result without scrutiny.
• Not testing how sensitive a conclusion is to the discount rate assumption. Since NPV can be highly sensitive to this single input, checking the result across a few plausible rate assumptions reveals how robust (or fragile) the conclusion actually is.
• Forgetting to account for all relevant cash flows, including any that occur beyond the initial projection window. A project with meaningful value beyond the years actually modeled will show an understated NPV if that later value isn’t captured somehow in the analysis.
• Confusing IRR with NPV when they happen to disagree on competing projects. When the two metrics point to different rankings for different-sized projects, NPV’s dollar-value framing is the more reliable guide for maximizing total value created.
• Assuming cash flow projections themselves are precise rather than estimates. NPV is only as reliable as the cash flow forecasts it’s built on — an elegant discounting calculation applied to overly optimistic or poorly researched cash flow estimates will still produce a misleading result, regardless of how carefully the discounting itself is done.
• Ignoring how uncertainty grows for cash flows further in the future. A cash flow projected five years out generally carries more forecasting uncertainty than one projected for next year — some practitioners address this by using a higher discount rate for longer-horizon, less certain projects specifically, though even a single consistent rate throughout is a common and reasonable simplification for most everyday NPV calculations.
• Comparing NPV figures across projects without confirming they use the same discount rate. Two projects evaluated at different discount rates aren’t directly comparable — a fair side-by-side comparison requires applying the identical rate assumption to every option under consideration.