NPV Calculator
NPV =
Profitable at this discount rate
Profitable at this discount rate
Discount each future cash flow CFᵢ back to today by dividing by (1 + r) raised to the period number i, then sum across every period (including period 0). A positive NPV means the project's discounted inflows exceed its discounted outflows at the chosen discount rate.
NPV = Σᵢ CFᵢ / (1 + r)ⁱ
Net Present Value (NPV) compares the value of money received in the future to the value of money you have today. Because a dollar received in five years is worth less than a dollar in hand — you could have invested it — each future cash flow gets divided by (1 + r)ⁿ before being added to the total, where r is your discount rate (your required rate of return, opportunity cost, or cost of capital). NPV sums all the discounted cash flows, including the initial investment as a negative number at period 0. A positive NPV means the project is expected to earn more than your discount rate; a negative NPV means it earns less. The discount rate is the lever — raise it and future cash gets discounted harder, pushing NPV down. This is the cornerstone metric of capital budgeting, used to evaluate factory expansions, real estate purchases, equipment upgrades, and any project where money goes out today to bring money back later.
A company is considering a project that requires a $1,000 investment today and will return $500 in year 1, $400 in year 2, and $300 in year 3. The company's required rate of return is 10%. Should they take the project?
NPV is highly sensitive to the discount rate. Always run sensitivity analysis at rates above and below your base assumption — a project that's a clear winner at 8% can flip negative at 12%.
Three ideas anchor every NPV calculation. First, the time value of money: a dollar today is worth more than a dollar tomorrow because you can invest today's dollar and earn a return. The discount rate quantifies how much more. Second, the NPV decision rule: accept any project with NPV > 0 at your required rate of return, reject any with NPV < 0, and treat NPV = 0 as exact break-even (the project earns precisely the discount rate). When ranking mutually exclusive projects, pick the one with the highest NPV in absolute dollars — not the highest IRR. Third, NPV's relationship to IRR: the internal rate of return is the discount rate that makes NPV equal zero. If IRR > your required return, NPV is positive at that required return; if IRR < your required return, NPV is negative. NPV and IRR usually agree on accept/reject for independent projects, but NPV is the more reliable decision rule when projects have unusual cash flow timing or scale.
List every cash flow with its period (year 0 is the initial investment, usually negative). Divide each cash flow by (1 + r)ⁿ, where r is the discount rate as a decimal and n is the period number. Sum all the discounted cash flows. The result is the NPV — positive means the project earns more than the discount rate, negative means it earns less.
NPV = Σᵢ CFᵢ / (1 + r)ⁱ, summed from i = 0 to N. CFᵢ is the cash flow at the end of period i (typically year 0 is the initial outlay as a negative number, and years 1 through N are subsequent inflows or outflows). r is the discount rate as a decimal, and N is the final period. Period 0 contributes CF₀ undiscounted because (1 + r)⁰ = 1.
Net Present Value is the sum of all of a project's cash flows after each has been discounted back to today's dollars at the chosen discount rate. It tells you, in present-day dollars, how much value the project is expected to create (positive NPV) or destroy (negative NPV) compared to investing the same money at the discount rate instead.
A positive NPV means the project is expected to earn more than the discount rate — it creates value. If you assumed your required return is 10% and NPV came out positive, the project clears that 10% hurdle. The size of the positive NPV is the present-value dollar amount the project adds beyond simply earning the discount rate on the same capital.
NPV is the dollar value a project adds at a given discount rate. IRR (internal rate of return) is the discount rate that makes NPV equal exactly zero. NPV gives an absolute dollar answer that depends on the rate you choose; IRR gives a single rate that depends only on the cash flow stream. They usually agree on accept/reject for a single project, but NPV is more reliable when comparing projects of different scale or with unusual cash flow patterns.
Use a rate that reflects the risk and opportunity cost of the project. For a corporate capital budgeting decision, the standard is the company's weighted average cost of capital (WACC), often in the 7–12% range. For a personal investment, use your next-best alternative return (a diversified stock index has averaged about 7% real). For a high-risk venture, add a risk premium. The rate matters — small changes can flip NPV from positive to negative.
Yes. A negative NPV means the project's discounted inflows are less than its discounted outflows at the chosen rate — the project is expected to earn less than the discount rate and destroys value relative to the alternative of earning that rate elsewhere. The standard decision rule is to reject negative-NPV projects.
Raising the discount rate lowers NPV because future cash flows get divided by a larger number — they're worth less in today's dollars. Lowering the rate raises NPV. Long-dated cash flows are especially sensitive: a cash flow 10 years out at 5% has a present value of about 61% of its face; at 10% it drops to 39%; at 15% it's only 25%. Always run NPV at a range of rates to see how sensitive your conclusion is.
Reference: Net present value is a standard capital budgeting metric defined in every introductory finance textbook (e.g., Brealey, Myers, and Allen, Principles of Corporate Finance; Ross, Westerfield, and Jaffe, Corporate Finance). The formula is consistent across academic and industry practice.
Net Present Value is the credit-weighted sum of every cash flow, with each future cash flow discounted back to today by dividing by one plus the discount rate raised to the period number:
Where:
A positive NPV means the project earns more than the discount rate — it creates value. A negative NPV means it earns less. NPV equal to zero means the project earns exactly the discount rate (the internal rate of return equals r).
Classic Capital Budget
A company evaluates a project requiring $1,000 up front and yielding declining returns of $500, $400, and $300 across years 1, 2, and 3. Required return: 10%.
NPV ≈ $10.52 — accept the project.
Just barely positive — the project earns slightly more than the 10% required return. At a 12% required return, NPV flips to about −$24.20 and the same project would be rejected.
Real Estate
Investor buys a rental for $200,000, nets $18,000/year in rent for 5 years, then sells in year 5 for $230,000 (so year-5 cash flow is $18K + $230K = $248K). Required return: 8%.
NPV ≈ $28,405 — accept at 8% required return.
If property values were flat (no $230K resale lift), NPV at 8% drops to about −$28,150 and the deal becomes a loser. NPV is exquisitely sensitive to your terminal value assumption.
High-Rate Sensitivity
Same $1,000 / $500 / $400 / $300 cash flow stream as Example 1, but a venture-style 20% required return.
NPV ≈ −$131.94 — reject at 20%.
Same project, same cash flows, opposite decision. The break-even discount rate (IRR) for this stream is about 10.65%; any required return above that flips NPV negative.