NPV Calculator
By Talcart · Last updated July 10, 2026
Initial investment (negative value)
NPV (Net Present Value) Guide
Understanding NPV
Basic Formula
- NPV = Σ (CFt / (1 + r)^t)
- Where: CFt = Cash flow at time t, r = Discount rate
- Example: -$1,000 now + $500 yearly for 3 years at 10% discount rate
Decision Rules
- NPV > 0: Investment adds value
- NPV < 0: Investment destroys value
- NPV = 0: Investment breaks even
NPV Calculator
This NPV calculator discounts a stream of future cash flows back to today's dollars and nets them against the upfront cost: pay $1,000 now, receive $500 a year for 3 years, and at a 10% discount rate the project is worth +$243.43 today. A positive result means the investment beats your required return; a negative one means it destroys value.
Key facts
- Paying $1,000 today for $500 a year over 3 years has an NPV of $243.43 at a 10% discount rate.
- $1,000 receivable in 10 years is worth $508.35 today at a 7% discount rate; a dollar due in 30 years at 8% is worth just $0.0994.
- NPV equals zero exactly when the discount rate equals the project's IRR -- for a -$10,000 / +$3,000 x 5-year stream, that break-even rate is 15.24%.
What is the NPV Calculator?
Net present value (NPV) is the sum of all of an investment's cash flows -- outflows and inflows alike -- after each has been discounted to its value today at a chosen rate. It rests on the time value of money: a dollar received later is worth less than a dollar now, because today's dollar could be earning the discount rate in the meantime. NPV is the gold-standard capital-budgeting metric because it states, in today's dollars, exactly how much value a project adds beyond the return the money could earn elsewhere.
How does the NPV Calculator work?
Each cash flow CF_t is divided by (1 + r)^t, where r is the discount rate and t the number of periods until it arrives, then everything is summed: NPV = sum of CF_t / (1 + r)^t. Discounting is compound interest run backward -- $1,000 due in 10 years at a 7% rate is worth $508.35 today, because $508.35 compounding at 7% grows back to $1,000. The initial outlay enters at t = 0 undiscounted and negative. Raising the discount rate shrinks every future term, which is why long-dated projects are acutely rate-sensitive.
What is the NPV Calculator formula?
- CF_t – cash flow at time t
- r – discount rate
- t – period index
NPV of a Project: -$10,000 Today, +$3,000 at Each Year-End for 5 Years
| Discount Rate | NPV | Verdict |
|---|---|---|
| 4% | $3,355.47 | Accept |
| 6% | $2,637.09 | Accept |
| 8% | $1,978.13 | Accept |
| 10% | $1,372.36 | Accept |
| 12% | $814.33 | Accept |
| 15% | $56.47 | Marginal |
| 15.24% (IRR) | $0.00 | Break-even |
How do you use the NPV Calculator?
- Enter the discount rate.
- Enter cash flows for each period (negative outflows, positive inflows).
- Read NPV; positive means the project beats the discount rate.
Worked example
| Scenario | −$1,000 now, +$500/year for 3 years, discount rate 10% |
| Calculation | −1000 + 500/1.1 + 500/1.21 + 500/1.331 |
| Result | NPV ≈ $243.43. |
Common use cases
Tips & best practices
Even a small change in discount rate can flip a long-dated project from positive to negative NPV — sensitivity-test it.
Frequently asked questions
A positive NPV means the investment returns more than the discount rate you demanded, creating that many dollars of extra value in today's terms. An NPV of +$1,372.36 on a $10,000 project at a 10% rate says: after earning your required 10%, the project hands you a further $1,372.36. Zero NPV means it exactly matches the required return; negative means the money is better deployed elsewhere.
Use the return the money could earn in an alternative of similar risk -- for companies, the weighted-average cost of capital (WACC), commonly in the 7-12% range; for personal decisions, your expected portfolio return or borrowing cost. The choice is decisive: the same -$10,000 / +$3,000-a-year project is worth $2,637.09 at 6% but only $56.47 at 15%.
Discount each cash flow by dividing it by (1 + r) raised to the year it arrives, then add everything including the negative initial cost. For -$1,000 now and $500 for 3 years at 10%: 500/1.1 = $454.55, 500/1.21 = $413.22, 500/1.331 = $375.66; those sum to $1,243.43, minus the $1,000 outlay leaves an NPV of $243.43.
NPV reports value created in dollars at your chosen discount rate; IRR reports the discount rate at which NPV would be exactly zero. They agree on accept/reject decisions -- NPV is positive precisely when IRR exceeds your rate -- but can rank competing projects differently. Finance practice prefers NPV for rankings because it measures total dollars of value, not just a percentage.
Because every future cash flow is divided by (1 + r)^t, a larger r shrinks each term -- and distant cash flows shrink fastest, since the exponent compounds the effect. A $1,000 inflow in year 10 is worth $675.56 today at 4% but only $385.54 at 10%. This is why long-horizon projects can flip from clearly positive to negative NPV on a modest rate change.
Yes. A project can return more cash than it costs in raw dollars yet still carry a negative NPV if those returns arrive too slowly to beat the discount rate. Receiving $15,000 total on a $10,000 outlay sounds profitable, but spread evenly over 5 years at a 16% required return it discounts to less than the cost (NPV of about -$177). NPV screens for beating your alternative, not merely breaking even.