ADVERTISEMENT

Mobile Banner
320×100

Net Present Value (NPV) Calculator

Calculate the present value of future cash flows to evaluate investment profitability

NPV Formula

Net Present Value
Loading formula...
Present Value Factor
Loading formula...
Profitability Index
Loading formula...
$
%
Cash Flow Year

Understanding Net Present Value

Net Present Value (NPV) is a core financial metric used to evaluate the profitability of an investment or project. It calculates the difference between the present value of cash inflows and the present value of cash outflows over a period of time. The fundamental principle is that money today is worth more than the same amount in the future due to its earning potential.

NPV accounts for the time value of money by discounting future cash flows back to their present value using a discount rate. This rate typically reflects the cost of capital or the required rate of return. A positive NPV indicates the investment should generate more than the minimum required return.

Capital budgeting decisions, investment analysis, and project evaluation all rely heavily on NPV analysis. It's considered one of the most reliable methods for making investment decisions because it accounts for both the magnitude and timing of cash flows.

NPV Decision Rules

Positive NPV

Accept the investment. It generates returns above the required rate and creates value.

Negative NPV

Reject the investment. It fails to meet the required return and destroys value.

⚖️

Zero NPV

Indifferent. The investment exactly meets the required return - no value created or destroyed.

📊

Comparing Projects

When mutually exclusive, choose the highest positive NPV. It creates the most value.

Choosing the Right Discount Rate

The discount rate is crucial to NPV calculation. Different rates can lead to dramatically different conclusions about an investment.

Rate TypeWhen to UseTypical RangeNotes
WACC Corporate projects 6-12% Most common for businesses
Cost of Equity Equity-funded only 8-15% Higher risk = higher rate
Hurdle Rate Internal targets 10-20% Company-specific threshold
Risk-Free + Premium Risk adjustment Treasury + risk Add premium for project risk
Opportunity Cost Alternative investments Best alternative return What else could you earn?
Inflation Rate Real vs nominal 2-4% Adjust for purchasing power

Common NPV Mistakes to Avoid

⚠️

Ignoring Opportunity Costs

Include the best alternative use of resources. If you're using existing equipment, include what you could earn by selling or renting it.

📉

Wrong Discount Rate

Using a rate too low overvalues projects. Too high undervalues them. Match the rate to the project's actual risk profile.

🔮

Overly Optimistic Cash Flows

Be realistic about future cash flows. Consider multiple scenarios and use probability-weighted estimates for better accuracy.

💰

Forgetting Working Capital

Projects often require inventory and receivables investment. Include initial working capital needs and recovery at project end.

How to use this NPV calculator

  1. Enter the Initial Investment — the total upfront cash outflow needed to start the project, including equipment, installation, and any initial working capital. Use the positive amount; the calculator treats it as the year-0 outflow.
  2. Enter the Discount Rate (%) — your weighted average cost of capital (WACC), hurdle rate, or required return. The field defaults to 10%; raise it for riskier projects and lower it for safer ones.
  3. Click + Add Year to add each year of expected cash flow, then enter the net cash flow for that year. Cash flows can be uneven across years — enter each year individually rather than averaging.
  4. Add as many years as the project lasts. You can remove a year with the Remove button if you change the project horizon.
  5. Click Calculate NPV. The calculator returns Net Present Value, Total Present Value of inflows, Profitability Index, Simple Payback, and an accept / reject / break-even decision based on the sign of NPV.

Examples

Equipment purchase: clear accept at 10% cost of capital

A small manufacturer is evaluating a $100,000 packaging machine expected to produce $30,000 of net cash flow each year for 5 years. The company's WACC is 10% and there is no salvage value at the end of the project.

ResultNPV is about $13,724, Profitability Index is about 1.14, and the decision is Accept.

Each $30,000 inflow is discounted at 10%: $30,000 / 1.10 = $27,273 for year 1, then divided by 1.10² for year 2, and so on through year 5. Those five present values sum to roughly $113,724. Subtract the $100,000 initial investment to get NPV ≈ $13,724. Because NPV is positive and PI is above 1.0, the project clears the 10% hurdle and creates shareholder value.

Same project, higher discount rate flips it to marginal

Same $100,000 machine and the same $30,000-per-year cash flows for 5 years, but the project is being evaluated for a riskier division with a 15% required return. At 20% required return the picture changes again.

ResultAt 15% the NPV drops to about $565 (marginal accept). At 20% it falls to about −$10,282 (reject).

Higher discount rates shrink every future dollar more aggressively. The 5-year annuity factor at 15% is 3.3522 instead of 3.7908 at 10%, so the present value of inflows is only $100,565 — barely above the $100,000 outlay. At 20% the annuity factor falls to 2.9906 and PV of inflows is just $89,718, giving a clearly negative NPV. The same project can be a 'go' or 'no-go' depending on the rate, which is why discount-rate selection matters as much as the cash-flow forecast.

Uneven cash flows: a growing SaaS investment

A founder is evaluating a $50,000 build-out for a new SaaS module. Net cash flow is expected to ramp as the product matures: $10,000 in year 1, $18,000 in year 2, $25,000 in year 3, $30,000 in year 4, and $35,000 in year 5. The required return is 12%.

ResultNPV is about $29,998, Profitability Index is about 1.60, and the decision is Accept.

Each year is discounted individually: $10,000 / 1.12 = $8,929, $18,000 / 1.12² = $14,349, $25,000 / 1.12³ = $17,795, $30,000 / 1.12⁴ = $19,066, and $35,000 / 1.12⁵ = $19,860. The present values sum to about $79,998. Subtract the $50,000 investment for NPV ≈ $29,998. The high PI of 1.60 reflects that even with back-loaded cash flows, the project earns 60 cents of present value for every dollar invested at the 12% hurdle.

How it works

The calculator implements the textbook NPV formula NPV=t=0nCFt(1+r)tNPV = \sum_{t=0}^{n} \frac{CF_t}{(1+r)^t}. The initial investment is treated as the year-0 outflow (CF₀ is negative), and each cash flow you enter for years 1 through n is divided by (1+r)t(1+r)^t to convert it into today's dollars. The discount rate rr is applied as a constant per-year rate.

Profitability Index is computed as PI=PV of future inflowsInitial InvestmentPI = \frac{\text{PV of future inflows}}{\text{Initial Investment}}, which is mathematically the same as 1 + NPV / Initial Investment. PI > 1.0 always implies NPV > 0. Simple Payback divides the initial investment by the cumulative undiscounted cash flow until the investment is recovered; it ignores the time value of money and is reported as a quick liquidity reference, not a decision rule.

The decision rule is mechanical: accept the project when NPV > 0, reject when NPV < 0, and treat NPV = 0 as the break-even hurdle. For mutually exclusive projects (you can only pick one), NPV is the preferred ranking metric because it measures absolute dollar value created — which is what shareholders ultimately receive — rather than a percentage return that can be misleading when projects differ in size or duration.

When to use this calculator

  • Deciding whether a single project clears your cost of capital. Use NPV to convert a forecast of uneven future cash flows into a single dollar number that answers, 'Does this investment earn more than my required return?' A positive NPV at your WACC is the green light to commit capital.
  • Comparing mutually exclusive investment options. When you can only pick one project — buy versus build, equipment A versus equipment B, expand here versus there — rank options by NPV and choose the highest positive value. This is the metric most consistent with maximizing firm value.
  • Valuing assets that produce future cash flows. NPV is the engine behind discounted cash flow (DCF) valuation of stocks, bonds, rental properties, and businesses. Feed in the expected free cash flows and your required return, and NPV tells you the most you should pay today.
  • Testing how robust a decision is to changing assumptions. Run the calculator with a higher discount rate, lower year-by-year cash flows, or a shorter horizon to see how quickly NPV flips negative. If small changes break the project, treat the result with skepticism even when the base case looks great.

Common mistakes to avoid

  • MistakeUsing accounting profit instead of cash flow.
    FixNPV is built on after-tax cash flow: revenue minus cash operating costs minus cash taxes. Net income includes non-cash charges like depreciation that misstate the real timing and amount of cash.
  • MistakeIncluding sunk costs in the analysis.
    FixMoney already spent on feasibility studies, prototypes, or existing equipment is gone whether you proceed or not. Only incremental future cash flows that change because of the decision belong in the model.
  • MistakePicking a discount rate by gut feel.
    FixStart with the firm's WACC for typical projects. Add a risk premium of 2–5 percentage points for ventures riskier than the firm's average, and use a project-specific cost of capital when entering a new business line.
  • MistakeMixing real and nominal numbers.
    FixEither forecast nominal cash flows (including expected inflation) and discount at a nominal rate, or forecast real cash flows (today's purchasing power) and discount at a real rate. Mixing the two systematically distorts NPV on long-horizon projects.
  • MistakeForgetting working-capital investment and recovery.
    FixNew projects often tie up cash in inventory and receivables at launch. Include the initial working-capital outflow as part of the investment, and add the recovered working capital back to the final year's cash flow.
  • MistakeIgnoring the terminal or salvage value.
    FixIf the asset has resale value, decommissioning cost, or a going-concern value at the end of the horizon, add it (net of tax) to the final year's cash flow before discounting. Omitting it understates NPV for long-lived assets.
  • MistakeRelying on payback period as the decision rule.
    FixPayback ignores everything after the recovery date and ignores the time value of money. A project with a 3-year payback and nothing after is far worse than one with a 4-year payback and ten more years of strong cash flow. Use payback only as a secondary liquidity check.

Frequently asked questions

What's the difference between NPV and IRR?

NPV is the dollar value a project adds after discounting all cash flows at your cost of capital. IRR is the discount rate that would make NPV exactly zero — a percentage return. NPV is generally preferred because it reflects absolute value creation, handles reinvestment assumptions cleanly, and works for non-conventional cash flows where IRR can have multiple solutions or none. When NPV and IRR disagree on ranking mutually exclusive projects, follow NPV.

How do I pick a discount rate?

For projects with risk similar to the firm's overall business, use the Weighted Average Cost of Capital (WACC). Public companies estimate WACC from their actual debt-and-equity mix and the cost of each component (often using CAPM for equity). For riskier ventures — new geographies, unproven technology — add a risk premium of 2 to 5 percentage points. For lower-risk cost-saving investments in core operations, WACC is usually fine unchanged.

What's the time value of money, and why does it matter for NPV?

The time value of money is the principle that a dollar today is worth more than a dollar in the future, because today's dollar can be invested to earn a return. NPV operationalizes this by discounting each future cash flow — dividing by (1+r) raised to the year — so flows received sooner contribute more to the result. Without discounting, you'd treat $1 in year 1 the same as $1 in year 10, which would systematically overvalue long-dated projects.

How does inflation factor into the NPV calculation?

Stay internally consistent. Either project nominal cash flows (which include expected price increases) and discount at a nominal rate, or project real cash flows (in today's purchasing power) and discount at a real rate. The Fisher equation links them: (1 + nominal) = (1 + real) × (1 + inflation). Mixing nominal cash flows with a real rate systematically inflates NPV; mixing real cash flows with a nominal rate systematically deflates it.

Can NPV be negative, and what does that mean?

Yes. A negative NPV means the project's discounted cash flows do not cover the initial investment at your required return — every dollar invested earns less than your cost of capital. The standard decision rule is to reject negative-NPV projects because they destroy shareholder value. Exceptions exist for strategic options (entering a market, blocking a competitor), but those benefits should be quantified rather than waved through.

How do I handle terminal value or salvage value?

Terminal value represents the worth of the asset or business at the end of the forecast horizon. For physical assets, it's the resale or scrap value net of disposal costs and tax. For going-concern businesses, it's often estimated as a perpetuity: TV = (final-year cash flow × (1 + g)) / (r − g), where g is the long-run growth rate. Add terminal value to the final-year cash flow in your input and discount the combined figure back to year 0 with the standard NPV formula.

How do I handle uncertain cash flows?

Three common approaches. First, use expected (probability-weighted) cash flows and discount at a risk-adjusted rate. Second, run scenarios — base, upside, downside — and look at the range of NPV outcomes rather than a single point estimate. Third, use Monte Carlo simulation to draw thousands of cash-flow paths from distributions on the key inputs and produce a probability distribution of NPV. For most non-listed decisions, scenario analysis is the practical sweet spot.

Should I include sunk costs in NPV?

No. Sunk costs are already spent regardless of whether you proceed, so they are irrelevant to the go / no-go decision. Only include incremental cash flows that occur because of the investment. Feasibility studies, prior R&D, and marketing already paid belong on the income statement of history, not in the NPV of the next project.

What if my project has cash flows that change sign more than once?

Non-conventional cash flow patterns — outflow, inflow, outflow again (think mine reclamation costs or a planned upgrade mid-life) — are well-handled by NPV but can give IRR multiple solutions or none. NPV remains a single, unambiguous number for any pattern, which is one reason it's preferred over IRR for irregular projects. Enter the negative years as negative numbers if your model supports it, or compute NPV in a spreadsheet for full flexibility.

Does the calculator handle taxes and depreciation?

Not directly — you enter cash flows you've already adjusted. For accurate NPV, the cash flows you input should be after-tax operating cash flow: (revenue − cash costs − depreciation) × (1 − tax rate) + depreciation. The depreciation tax shield (depreciation × tax rate) is real cash, so it stays in the calculation, but depreciation itself is added back because it isn't a cash outflow. Salvage value should be net of any tax on disposal gain.

Why is my answer slightly different from a spreadsheet's NPV function?

Spreadsheet NPV functions (e.g., Excel's =NPV) typically discount the first cash flow back one period and assume it occurs at the end of year 1, so to get a comparable result you subtract the initial investment separately: =NPV(rate, year1_cf : year_n_cf) − initial_investment. This calculator follows the same convention — initial investment at year 0, all entered cash flows at the end of their respective years. Differences usually come from year-0 versus year-1 timing assumptions, not the math itself.

Sources

Methodology

This calculator computes Net Present Value as NPV = Σ CF_t / (1+r)^t for t = 0 to n, with the initial investment treated as a negative cash flow at t = 0 and each user-entered cash flow discounted at the supplied constant rate r. Profitability Index is the present value of future inflows divided by the initial investment, mathematically equivalent to 1 + NPV / Initial Investment, so PI > 1.0 always coincides with NPV > 0. Simple Payback is reported on an undiscounted basis as a secondary liquidity reference. The accept / reject / break-even decision is driven by the sign of NPV.

Pro Tips

  • Bookmark this calculator for quick access in the future
  • Use the share button to send your results to others
  • Try different scenarios to compare outcomes
  • Check out our related calculators for more insights

Found this calculator helpful? Share it with others: