NPV Calculator — Free Net Present Value Calculator | AllInOneTools
💰 Free Finance Tool

NPV Calculator

Calculate the Net Present Value of any investment. Enter your discount rate and periodic cash flows to determine if a project creates or destroys value in today's dollars.

$
%
Future Cash Flows (by period/year)
+ Add Cash Flow
Net Present Value (NPV)
$21,382
at 10% discount rate
IRR
18.03%
Profitability Index
1.21
PV of Cash Flows
$121,382
Payback Period
3.1 yrs
PeriodCash FlowDiscount FactorPresent ValueCumulative PV

Net Present Value (NPV): The Gold Standard of Investment Analysis

Net Present Value is widely regarded as the most theoretically sound method for evaluating investments and capital projects. NPV answers the most fundamental question in finance: does this investment create value? By discounting all future cash flows back to their present value and subtracting the initial cost, NPV tells you exactly how much wealth an investment adds (or destroys) in today's dollars. A positive NPV means the project earns more than the required rate of return; a negative NPV means it falls short.

The NPV Formula

NPV = -C₀ + CF₁/(1+r) + CF₂/(1+r)² + ... + CFₙ/(1+r)ⁿ

Where:
C₀ = Initial investment
CFₙ = Cash flow in period n
r = Discount rate (cost of capital)

Example: $100,000 investment, 10% discount rate
Year 1: $30,000 → PV = $27,273
Year 2: $35,000 → PV = $28,926
Year 3: $40,000 → PV = $30,053
Year 4: $45,000 → PV = $30,735
Total PV = $116,987
NPV = $116,987 - $100,000 = $16,987

The discount rate represents the opportunity cost of capital — the return you could earn on an alternative investment with similar risk. For corporations, this is typically the Weighted Average Cost of Capital (WACC). For individual investors, it might be the expected return on a diversified portfolio or the rate on the next best alternative investment.

Choosing the Right Discount Rate

The discount rate is the most critical input in NPV analysis, and getting it wrong can completely change the decision. A rate too low overstates NPV and makes bad projects look good. A rate too high understates NPV and may reject value-creating projects. For corporate capital budgeting, WACC is the standard baseline, typically ranging from 8-12% for established companies. For private investments, many analysts add a risk premium of 3-5% above the risk-free rate to account for illiquidity, uncertainty, and execution risk.

NPV Decision Rule
NPV > 0: Accept — the project creates value above your required return. NPV = 0: Indifferent — the project exactly meets your required return. NPV < 0: Reject — the project destroys value relative to alternatives. When comparing mutually exclusive projects, choose the one with the highest NPV (not highest IRR).

NPV vs IRR: Strengths and Weaknesses

While NPV and IRR usually agree on accept/reject decisions, they have different strengths. NPV advantages: measures absolute value creation (not just percentages), handles non-conventional cash flows without multiple solutions, and correctly ranks mutually exclusive projects. IRR advantages: intuitive percentage format, easy to communicate, and doesn't require specifying a discount rate upfront. The best practice is to calculate both: use NPV as the primary decision criterion and IRR as a supplementary measure of capital efficiency.

The Profitability Index

The Profitability Index (PI) is a useful companion to NPV, defined as the ratio of present value of future cash flows to the initial investment. PI = PV of future cash flows / Initial Investment. A PI greater than 1.0 means the project creates value (equivalent to positive NPV). PI is particularly useful when capital is limited and you need to rank projects by efficiency — choose the combination of projects with the highest total NPV that fits within your budget.

Common NPV Pitfalls
Using the wrong discount rate is the most common error. Other pitfalls include: double-counting inflation (use nominal rates with nominal cash flows, or real rates with real cash flows, but never mix), ignoring terminal value in long-lived projects, being overoptimistic with cash flow projections, and forgetting to include working capital requirements and opportunity costs. Always perform sensitivity analysis on key assumptions.

NPV in Practice

In corporate finance, NPV analysis is the foundation of capital budgeting decisions. Companies rank proposed projects by NPV and allocate capital to those creating the most value. In real estate, NPV helps compare properties with different income profiles and holding periods. In mergers and acquisitions, discounted cash flow (DCF) analysis — which produces an NPV — is one of the primary valuation methods. Even personal financial decisions like evaluating a lease versus buy choice or comparing investment opportunities benefit from NPV thinking.

Frequently Asked Questions

What is NPV?
NPV (Net Present Value) is the sum of all future cash flows discounted to present value, minus the initial investment. Positive NPV = creates value; negative NPV = destroys value. It is the gold standard metric for investment decisions.
What discount rate should I use?
Use your cost of capital or required return. Corporations typically use WACC (8-12%). Individual investors may use their expected portfolio return or risk-free rate + risk premium. Higher risk = higher rate.
NPV vs IRR — which is better?
NPV is better for comparing projects (measures dollar value). IRR is better for quick efficiency comparisons (percentage). Use both together. For mutually exclusive projects, always use NPV.
What is the Profitability Index?
PI = PV of future cash flows / Initial Investment. PI > 1 means the project creates value. PI of 1.25 = $1.25 present value per $1 invested. Useful for ranking projects when capital is limited.
Can NPV be negative?
Yes. Negative NPV means the investment returns less than your required rate. It doesn't necessarily mean you lose money outright — just that the return doesn't meet your threshold. The project destroys value relative to alternatives.
How do I handle inflation in NPV?
Be consistent: use nominal discount rate with nominal cash flows (include inflation), or real discount rate with real cash flows (exclude inflation). Mixing nominal and real is the most common NPV error and will give incorrect results.