About the NPV Calculator
A dollar today is worth more than a dollar next year, and NPV is the tool that puts that idea into hard numbers. Our NPV Calculator discounts a project's future cash flows back to today's value and weighs them against the upfront investment required to get them.
How It Works
For each of the five years you enter a projected cash flow, the calculator discounts that amount back to its present-day value using your chosen discount rate, then sums all five discounted values and subtracts the initial investment. A positive result means the project is expected to create value beyond simply doing nothing with the money; a negative result means it isn't.
Formula & Methodology
Each future cash flow gets divided by (1 + r) raised to the power of how many years away it lands - year 1's cash flow is discounted once, year 5's cash flow is discounted five times over, which is why cash further in the future contributes less to the total even if the nominal dollar amount is identical. The discount rate you choose represents your required rate of return or cost of capital: the minimum return you'd need to make the investment worthwhile instead of putting the money elsewhere. Summing all five discounted values and subtracting the initial investment produces NPV in today's dollars, directly comparable to the cash you're putting in now.
Step-by-Step: Calculating It By Hand
- 1Estimate the cash flow you expect to receive in each of the next five years.
- 2Choose a discount rate that reflects your required return or cost of capital.
- 3Divide each year's cash flow by (1 + discount rate) raised to that year's power.
- 4Add up all five discounted cash flows.
- 5Subtract the initial investment from that sum to find NPV.
Examples
Value-creating project
A $50,000 investment returning $15,000 a year for 5 years at an 8% discount rate produces a positive NPV of roughly $9,900 - the project is expected to add value.
Marginal project at a higher rate
The same cash flows discounted at 15% instead of 8% produce a much smaller, possibly negative NPV - showing how sensitive the verdict is to your required rate of return.
Advantages
- Converts future cash flows into a single, comparable dollar figure in today's terms
- Directly incorporates the time value of money, unlike simple payback period math
- Gives a clear accept-or-reject signal once you've chosen a discount rate
- Makes it easy to stress-test a project against different rate assumptions
Common Mistakes
- Using an unrealistically low discount rate that makes a weak project look attractive
- Treating projected cash flows as guaranteed rather than estimates worth stress-testing
- Comparing NPV dollar amounts across projects of very different sizes without also checking IRR or a profitability index
- Forgetting that NPV is highly sensitive to the discount rate chosen, especially for cash flows further in the future
Edge Cases to Watch For
- This model only handles exactly five years of cash flows - a project with a shorter life can enter $0 for unused years, while a longer project needs a different tool or a terminal value added to year five.
- A higher discount rate always lowers NPV, since it more heavily penalizes cash flows further in the future - choosing an unrealistically low rate can make a mediocre project look artificially attractive.
- NPV assumes cash flows are known with certainty; in practice, run the calculation with optimistic and pessimistic cash flow estimates to see how sensitive the result is.
- A project can have a positive NPV at one discount rate and a negative NPV at another, which is exactly the relationship the IRR calculation is built to find.
Common Use Cases
- Evaluating whether a business investment or capital project is worth pursuing
- Comparing multiple project opportunities on a like-for-like basis
- Testing how sensitive a project's viability is to different required rates of return
- Supporting a capital budgeting decision with a defensible, standard financial metric