Net Present Value Calculator: Is This Project Worth It?
A net present value calculator answers one blunt question: is this project worth more than it costs, once you accept that future money is worth less than money in your hand right now? It shrinks every expected dollar by a discount rate, adds them up, and subtracts what you put in. Positive means the project creates value. Negative means you'd be better off keeping your money elsewhere.
What NPV means, in plain English
Imagine someone offers you $100 today or $100 a year from now. You take it today, every time: money today can earn interest or pay a bill for a year, while money a year away can do neither. That gap is the time value of money, and NPV prices it.
NPV converts every future dollar into current money. A dollar due in one year at 8% is worth about 93 cents now, since 93 cents at 8% grows to roughly a dollar in a year. A dollar due in four years is worth only about 74 cents now. The further away money sits, the harder it gets discounted. Add those values up, subtract your upfront cost, and you've got the NPV.
The rule is simple. Positive NPV means the project beats your discount rate. Negative NPV means it falls short, destroying value even when raw cash coming back exceeds what you put in. Zero means it earns exactly your discount rate, which most people set as their cost of capital.
Every input, explained
Initial investment. The money you put in at the start, at Year 0. It isn't discounted, since it leaves your pocket now. In our example that's $20,000. Later costs, like a Year 3 maintenance bill, go in as negative flows that year, not here.
Yearly cash-flow rows. The money each year brings in, after running costs and taxes. The calculator discounts these one by one, and order matters: Year 1 money is discounted once, Year 4 money four times, so a late dollar counts for less than an early one. Enter each year's net figure, not gross revenue, and give a losing year a negative number.
Discount rate (%/yr). The rate used to shrink future dollars, and it's the single judgement call in the calculation. A small business owner might use a loan rate, an investor the return of a comparable safe investment, a company its weighted average cost of capital. Pick it with care: the same project looks great at 4% and shaky at 17%.
A worked example: $20,000 in, four years out
Say you invest $20,000 in a side business paying $6,000, $7,000, $8,000, and $9,000 in Years 1 to 4, at 8%. The math runs like this.
- Work out each year's discount factor. The factor for Year t is 1 divided by 1.08 to the power t: 0.9259, 0.8573, 0.7938, and 0.7350 for Years 1 to 4. Each is the current-money value of one dollar arriving in that year.
- Multiply each cash flow by its factor. Year 1: $6,000 times 0.9259 equals $5,555.56. Year 2: $7,000 times 0.8573 equals $6,001.37. Year 3: $8,000 times 0.7938 equals $6,350.66. Year 4: $9,000 times 0.7350 equals $6,615.27. Year 4 pays most yet is worth less discounted.
- Add them up. $5,555.56 + $6,001.37 + $6,350.66 + $6,615.27 = $24,522.85, the present value of inflows.
- Subtract the investment. $24,522.85 minus $20,000 = $4,522.85. That's the NPV, and because it's positive, the project creates value at 8%. The profitability index, $24,522.85 divided by $20,000, is 1.23.
| Year | Cash flow | Discount factor at 8% | Present value |
|---|---|---|---|
| 0 | -$20,000.00 | 1.0000 | -$20,000.00 |
| 1 | $6,000.00 | 0.9259 | $5,555.56 |
| 2 | $7,000.00 | 0.8573 | $6,001.37 |
| 3 | $8,000.00 | 0.7938 | $6,350.66 |
| 4 | $9,000.00 | 0.7350 | $6,615.27 |
| Total | $10,000.00 net cash | NPV $4,522.85 |
Compare the two bottom lines. Undiscounted, the project returns $30,000 on $20,000, a $10,000 gain. Discounted at 8%, that gain is worth only $4,522.85. Only the second answers the real question: after paying for the wait, did you come out ahead?
How the verdict changes as rates rise
Run the same project at different rates. At 4%, the NPV is $7,046.33. At 8%, it's $4,522.85. At 12%, it falls to $2,351.40, still positive but barely half the 8% figure. The project hasn't changed. Only the price of waiting has gone up.
| Discount rate | Present value of inflows | NPV | Verdict |
|---|---|---|---|
| 4% | $27,046.33 | $7,046.33 | Accept |
| 8% | $24,522.85 | $4,522.85 | Accept |
| 12% | $22,351.40 | $2,351.40 | Accept, but thinner |
Keep raising the rate and the verdict flips: at 16% the NPV is down to $470.44, and at 18% it turns negative at -$376.82. The break-even point, where NPV hits zero, sits at about 17.09%, a rate with its own name, the internal rate of return: the highest rate this project can survive. Above 17.09%, walk away. Below it, the project pays its way.
Why NPV beats the payback period
Payback asks: how fast do I get my money back? Our project recovers its $20,000 during Year 3, when $6,000 plus $7,000 plus $8,000 reaches $21,000. But payback ignores everything after the payback date, and the time value of money entirely. A project that pays you back in three years and then nothing looks identical to one paying for a decade. NPV counts every year and prices the wait, which is why it's the better test. Use payback as a gut check on risk, and let NPV decide.
Common mistakes
- Using gross revenue instead of net cash flow. The calculator wants cash left after running costs and taxes, not sales. Feeding it revenue inflates each year's present value and can turn a loser into a winner.
- Picking a discount rate out of thin air. A 5% rate when your loan costs 12% flatters the project badly. Tie the rate to something real: your borrowing cost, or a comparable return.
- Forgetting later costs. A machine needing a $4,000 overhaul in Year 3 isn't free then. Enter it as a negative cash flow that year, or your NPV is overstated.
- Treating a small positive NPV as a green light. An NPV of $200 on a $200,000 project sits within the margin of your estimates being off. Big projects deserve a safety margin, not just a number above zero.
Practical tips
Run the calculation at three rates: your best guess, and a couple of points either way. If the verdict survives all three, trust it more than a single number. When comparing two projects, compare NPVs only if they need similar money and run for similar lengths; otherwise the profitability index is fairer, since it measures value per dollar invested. Re-run the numbers when your borrowing cost changes: a small-looking rise can halve an NPV.
Frequently asked questions
What does a positive NPV actually mean for my project?
It means the project earns more than your discount rate, creating value in current-money terms. Our example's $4,522.85 at 8% says the project is worth that much more than its $20,000 cost, after paying for the wait. A negative NPV says the opposite: you'd do better elsewhere.
How do I choose a discount rate for NPV?
Tie it to something real. If you borrow, use your loan rate. If it's your own money, use the return of the best alternative at similar risk. Companies often use their weighted average cost of capital. Guessing low flatters the project, so test a higher rate too.
Why is NPV lower than the plain cash profit?
Because future dollars are discounted. Our project nets $10,000 in raw cash, but at 8% that gain is worth only $4,522.85 in current money. The difference is the price of waiting: tied-up money could have earned returns elsewhere, and NPV charges for it.
What is the profitability index, and when should I use it?
It's the present value of inflows divided by the initial investment. Our example gives 1.23: each dollar returns $1.23 in current-money terms. Use it when choosing between projects of different sizes, since raw NPV favors big projects and the index shows value per dollar.
Can NPV be positive but the project still be a bad idea?
Yes. NPV trusts your cash-flow forecasts, and forecasts are often optimistic. It also ignores risks absent from the numbers, like a key customer leaving or a regulation changing. Treat a small positive NPV as a maybe, run it at a higher rate, and check forecasts before committing real money.
Related calculators: IRR Calculator, Finance Calculator, and ROI Calculator.
Discounting separates a hopeful guess from a real decision: once you've seen a $10,000 cash gain shrink to $4,522.85 just by pricing the wait, you'll never look at a multi-year promise the same way again. Run your own numbers through the calculator above, test them at a higher rate than you expect, and let the result decide. More plain-English walkthroughs like this one live on the CalcMega Blog.
Use this guide to understand the calculation, not as a recommendation to fund any particular project. Forecasts are estimates and outcomes will differ, so check current rates and your own figures before committing money.
Further reading: the CFPB's plain-language resources on weighing the costs and benefits of a financial decision pair well with the discounting habit taught here. See consumerfinance.gov.