Would you pay $1,000 today to get $1,200 back over three years? It sounds like a clear win, since you gain $200. But money that arrives later is worth less than money in your hand now. Net present value, or NPV, puts every future dollar into today’s terms so you can see the real gain. In this guide, that $200 shrinks to just $17.63 once time is priced in.
| What NPV means | Today’s value of future cash, minus the upfront cost |
|---|---|
| Formula | NPV = sum of CF_t / (1 + r)^t, minus C0 |
| Decision rule | Positive NPV adds value; negative NPV loses value |
| Biggest lever | The discount rate: a higher rate lowers NPV |
| Example | $1,000 cost, then $300, $400, $500 at 8% gives NPV $17.63 |
NPV Quick Reference Card
Keep this table handy while you read. It holds every piece of NPV you need for a first pass at any investment.
| Item | What to use | Plain meaning |
|---|---|---|
| Cash flow (CF_t) | Net cash in year t | Money in, minus money out, for that year |
| Discount rate (r) | Your required return | What your money could earn elsewhere |
| Discount factor | 1 / (1 + r)^t | Today’s value of $1 received in year t |
| Initial cost (C0) | Cash paid at year 0 | Already in today’s dollars, so no discounting |
| NPV above 0 | Accept | Beats your required return |
| NPV below 0 | Reject | Falls short of your required return |
| NPV exactly 0 | Break-even | Earns exactly the discount rate |
The table assumes each cash flow lands at the end of its year. That is the standard textbook and spreadsheet convention, and our tool uses it too.
What Does Net Present Value Actually Measure?
NPV measures how much richer an investment makes you in today’s dollars, after it repays its cost and your required return. A positive number is value created. A negative number is value lost.
The idea rests on the time value of money. A dollar today can be invested and grow, so a dollar next year is worth less right now. At 8%, $100 arriving in one year is worth $92.59 today. The same $100 arriving in 10 years is worth only $46.32 today.
Governments use the same logic. The federal budget office tells agencies to judge projects by discounted net benefits, which is benefits minus costs after discounting. Businesses and farms apply the identical test to machines, buildings, and herds.
- Present value
- What a future amount is worth today at a chosen discount rate.
- Discount rate
- The yearly return you require, often your borrowing cost or your next best option.
- Opportunity cost
- The return you give up by tying money into this project instead of another.
- Profitability index
- Present value of the returns divided by the upfront cost. Above 1 means positive NPV.
- Break-even rate
- The discount rate that makes NPV exactly zero, also called the internal rate of return.
How Do You Calculate NPV by Hand?
Divide each year’s cash flow by (1 + r) raised to its year number, add the results, then subtract the upfront cost. Three steps cover every NPV problem, from a small upgrade to a large plant.
Take a project that costs $1,000 today. It returns $300, $400, and $500 over the next three years. Your required return is 8% a year.
| Year | Cash flow | Discount factor | Present value |
|---|---|---|---|
| 0 | -$1,000 | 1.0000 | -$1,000.00 |
| 1 | $300 | 0.9259 | $277.78 |
| 2 | $400 | 0.8573 | $342.94 |
| 3 | $500 | 0.7938 | $396.92 |
| NPV | $17.63 | ||
The three returns are worth $1,017.63 today. Subtract the $1,000 cost, and the NPV is $17.63. The profitability index is 1,017.63 divided by 1,000, or 1.0176.
Notice how the later dollars shrink the most. The year 3 payment loses about $103 to discounting, while year 1 loses only about $22. For longer or uneven cash flows, the NPV calculator for uneven yearly cash flows runs this table for you in seconds.
Why Does the Discount Rate Change the Answer So Much?
A higher discount rate shrinks every future cash flow, so NPV falls as the rate rises. The same project can pass at one rate and fail at another.
Run the $1,000 project again at 12% instead of 8%. The returns are now worth only $942.62 today. The NPV drops to -$57.38, and the project fails. Nothing changed except the return you demand.
The chart below plots NPV across five rates. At 0%, NPV is the plain $200 gain. At 16%, it sinks to -$123.79. The break-even rate has its own guide, internal rate of return explained, so we only flag it here.
Where the Rate Comes From
Most people start with their cost of borrowing. A farm paying 8% on a loan needs a project to beat 8%, or the loan eats the gain. Investors with spare cash often use the return from their next best choice instead. Riskier projects deserve a higher rate, because their cash flows are less certain. Pick the rate before you run the numbers, so the answer cannot steer your choice.
How Should You Read a Positive or Negative NPV?
A positive NPV means the project beats your required return, and a negative NPV means it falls short. Zero means it earns exactly the rate you chose, no more and no less.
A negative NPV does not always mean you lose money. Our project at 12% still returns $1,200 on $1,000. It simply earns less than 12% a year, so the cash would do better in the 12% option.
Timing matters as much as totals. Flip the order to $500, $400, then $300, and the NPV at 8% rises to $44.05. The total is still $1,200, but more of it arrives early. Plain return on investment misses this effect. Our guide on ROI versus annualized return shows why a yearly rate tells you more than a total.
Compare Projects of Different Sizes
NPV is in dollars, so bigger projects post bigger numbers. Scale our example up ten times, and NPV becomes $176.33. The profitability index stays at 1.0176, which helps rank projects when cash is limited.
What Can NPV Leave Out?
NPV is only as good as the cash flow forecasts and the discount rate you feed it. It cannot fix optimistic guesses, and it ignores values you cannot put in dollars.
Test several scenarios instead of one. Run a low case, a middle case, and a high case, then see how often NPV stays positive. Our example flips from positive to negative within four points of rate, which tells you it is a thin margin.
Leave out money already spent. Federal guidance says past costs typically should not count, because they do not change with today’s choice. A $300 study you already paid for does not belong in year 0.
Match your rate to your cash flows. Use a rate that includes inflation for cash flows that include price rises. Use a real rate for cash flows stated in today’s prices. Mixing the two skews the answer.
Count every cash flow the project truly causes. Include repairs, extra labor, and any resale value at the end. A machine that sells for $200 in year 3 adds that money to the year 3 cash flow.
The NPV Calculator takes your discount rate, upfront cost, and yearly cash flows, then returns the NPV and profitability index.
Questions People Ask About NPV
What Is a Good NPV?
Any NPV above zero is good, because the project beats your required return. A larger NPV adds more value in today’s dollars. Compare projects of different sizes with the profitability index as well.
What Discount Rate Should I Use for NPV?
Use the return you could earn on your next best option, or your cost of borrowing. Many analysts start near their loan rate and add a margin for riskier projects. Test a few rates to see how sensitive the answer is.
Is NPV Better Than IRR?
NPV is usually the safer guide when you must rank projects. It shows value in dollars and uses one clear rate. IRR gives a single percentage, but it can mislead when projects differ in size or cash flows change sign more than once.
Can NPV Be Negative Even When I Make a Profit?
Yes. A project that returns $1,200 on $1,000 still shows an NPV of -$57.38 at a 12% rate. The profit exists, but it earns less than 12% a year, so another option would do better.
Does NPV Include the Initial Investment?
Yes. The upfront cost sits at year 0 and is subtracted without discounting, since it is already in today’s dollars. Leave the cost out, and you get the present value of the returns instead of NPV.
Where These Numbers Come From
References Used in This Article
This article is general finance education, not investment advice. All examples use made-up cash flows computed with end-of-year discounting. Reviewed for accuracy by Prof. Dr. Khalil Mudassar, PhD. Last updated September 27, 2026.
Author
Shakeel Muzaffar is the Founder and Editor-in-Chief of MultiCalculators.com, bringing over 15 years of experience in digital publishing, product strategy, and online tool development. He leads the platform's editorial vision, ensuring every calculator meets strict standards for accuracy, usability, and real-world value. Shakeel personally oversees content quality, formula verification workflows, and the platform's commitment to publishing tools that are genuinely useful for students, professionals, and everyday users worldwide.




