Team
finance

Net Present Value Calculator

Net present value quantifies whether an investment or project destroys or creates wealth by comparing the present value of all future cash inflows against the initial outlay. Financial analysts, corporate finance teams, and individual investors use NPV to rank competing projects, approve capital budgets, and assess acquisition targets. A positive NPV means the investment exceeds your required return; negative NPV signals value destruction.

Last updated:

Creators Arturo Barrantes, MSc Finance
4,045 people find this calculator helpful

Understanding Net Present Value

Net present value represents the dollar amount of value a project adds or subtracts from your wealth today. It accounts for the time value of money—the principle that cash today is worth more than the same amount tomorrow because it can be invested to earn returns.

Consider a simple scenario: you could deposit $1,000 in a savings account earning 5% annually and have $1,050 after one year. Conversely, $1,050 received in one year has a present value of only $1,000 at that 5% discount rate. NPV applies this logic across multiple years and cash flows, reducing future money to today's equivalent value.

Projects with positive NPV enhance shareholder wealth, while negative NPV projects destroy it. When comparing two mutually exclusive investments, choose the one with the higher NPV.

The NPV Calculation

The formula discounts each annual cash flow by raising the discount factor to the power of the year number, then sums all present values minus the initial investment:

NPV = −C₀ + C₁/(1+r)¹ + C₂/(1+r)² + C₃/(1+r)³ + ... + Cₙ/(1+r)ⁿ

  • C₀ — Initial outlay (entered as a positive number; the formula applies a negative sign)
  • C₁, C₂, ... Cₙ — Expected cash inflows (or outflows if negative) in years 1 through n
  • r — Discount rate (often the weighted average cost of capital or required rate of return, expressed as a decimal)
  • n — Number of years over which the project generates cash flows

Worked Example: Comparing Two Projects

A manufacturing firm evaluates two five-year equipment investments, each requiring $10,000 upfront. The company's cost of capital is 5%.

Project A: Year 1–5 cash flows are $5,000, −$1,000, $3,000, $3,000, $2,000.
Project B: Year 1–5 cash flows are $1,000, $1,000, $1,000, $5,000, $4,000.

Discounting Project A's flows: $5,000/1.05 + (−$1,000)/1.05² + $3,000/1.05³ + $3,000/1.05⁴ + $2,000/1.05⁵ = $11,481.55, yielding NPV = $1,481.55.
Project B's discounted flows sum to $10,861.48, so NPV = $861.48.

Project A creates more value and should be selected, despite Project B's steadier early-year returns.

NPV Versus Internal Rate of Return

The internal rate of return (IRR) is the discount rate at which NPV equals zero—the project's break-even return. While IRR is intuitive (expressed as a percentage), NPV is more reliable for capital allocation decisions because it directly measures value added in dollars and avoids ranking distortions when projects have different scales or cash flow patterns.

Use NPV as your primary decision metric. IRR is useful as a secondary check: if IRR exceeds your cost of capital, the project likely has positive NPV. However, mutually exclusive projects with different lifespans or sizes can rank differently under NPV and IRR; always prioritize NPV.

Common Pitfalls When Computing NPV

Avoid these mistakes when applying NPV analysis to investment decisions.

  1. Misjudging the Discount Rate — Selecting too low a discount rate inflates NPV and leads to overinvestment in mediocre projects. Ensure your rate reflects both the project's risk and your company's cost of capital. A riskier venture warrants a higher discount rate to compensate for uncertainty.
  2. Ignoring Non-Quantifiable Factors — NPV captures financial returns but misses strategic benefits (brand enhancement, market entry, workforce skills) or intangible costs (environmental risk, reputation damage). Use NPV as a starting point, then factor in qualitative considerations before making final decisions.
  3. Assuming Forecasts Are Certain — Cash flow projections are estimates, not certainties. Conduct sensitivity analysis: vary discount rates and cash flows within plausible ranges to see how NPV changes. This reveals which assumptions drive your decision and exposes dangerous dependencies.
  4. Forgetting Timing Matters — A $1,000 inflow in Year 1 is worth far more than $1,000 in Year 10 at any positive discount rate. Prioritize projects that generate cash early. Projects bunching returns in distant years suffer heavier discounting and lower NPV.

Frequently Asked Questions

What does a positive NPV indicate for an investment?

A positive NPV means the project's cash inflows, adjusted for the time value of money, exceed the initial and ongoing costs. The investment returns more than your required rate of return, thereby increasing shareholder wealth. For example, an NPV of $50,000 signals that the project adds $50,000 in present-value terms beyond your cost of capital. In principle, accept all projects with positive NPV if capital is unlimited; if capital is constrained, rank projects by NPV and fund from highest to lowest.

How do you choose a discount rate for NPV calculations?

The discount rate typically equals your weighted average cost of capital (WACC), which blends the cost of debt and equity financing adjusted for your capital structure. Alternatively, use your hurdle rate—the minimum return you require given the project's risk level. A typical company might use 8–12% for standard projects, 15%+ for high-risk ventures like R&D, and 4–6% for low-risk infrastructure. The higher the risk, the higher the discount rate; this conservative approach prevents overpaying for uncertain cash flows.

Can you have a negative NPV and still pursue a project?

Yes, under strategic circumstances. A negative NPV project might be justified if it enables a higher-NPV opportunity later, reduces competitive threats, enters a critical market, or improves operational resilience. However, negative NPV means the project fails financial hurdle rates on a standalone basis. If you undertake it, do so knowingly and ensure the strategic rationale outweighs the quantified value loss. For most routine capital decisions, reject negative-NPV projects.

How is expected cash flow different from NPV?

Expected cash flow (also called present value of inflows) is the sum of all future cash inflows discounted to present value, excluding the initial investment. NPV subtracts the initial investment from this figure. If expected cash flow is $110,000 and your initial outlay is $100,000, NPV = $10,000. This distinction matters: expected cash flow shows the present value of revenues, while NPV tells you the net gain or loss after paying the upfront cost.

Should you always pick the project with the highest NPV?

When projects are independent and you have sufficient capital, yes—accept all positive-NPV projects. When projects are mutually exclusive (you can only choose one), the highest NPV project is preferred because it maximizes value creation. However, ensure the projects are truly comparable: if one requires $50,000 and another $500,000, both positive but different scales, profitability index (NPV divided by initial investment) can also inform ranking. Also consider intangibles, strategic fit, and risk tolerance before finalizing your choice.

What is the relationship between NPV and stock price?

In theory, accepting positive-NPV projects increases a company's intrinsic value and should raise stock price over time. Markets reward profitable capital allocation. Conversely, a pattern of negative-NPV investments erodes shareholder value and depresses stock performance. However, the stock market reacts to near-term earnings, sentiment, and macroeconomic conditions as well, so NPV-positive decisions may not immediately boost share price. Nevertheless, disciplined NPV-based capital budgeting is a cornerstone of long-term wealth creation.

More finance calculators (see all)

Earned Value Management Calculator Scrap Silver Calculator Debt-to-Capital Ratio Calculator Mortgage Refinance Calculator CAPM Calculator Accounting Profit Calculator Free Cash Flow to Equity Calculator Off-Days Calculator