NPV Calculator
Enter the upfront cost (negative = money out, positive = money in)
Required rate of return or cost of capital
Positive = inflow, negative = additional outflow
Enter your initial investment, discount rate, and annual cash flows to see NPV instantly.
A positive NPV means the investment creates value at the given discount rate.
This NPV calculator takes your initial investment, discount rate, and annual cash flows, then tells you whether the project is worth doing, in dollars, not vague percentages. Most investment decisions get made on gut feel or raw profit totals, which completely ignores the fact that money you receive three years from now is worth less than money you receive today. Read on and you'll also find out why two projects with identical total returns can have wildly different NPVs.
By the end of this page, you'll know:
- What net present value actually measures and why raw profit totals are misleading
- What the discount rate is and how to choose the right one for your project
- How to calculate NPV step by step, using a real worked example with named numbers
- The most common NPV mistake and how to avoid making it
How to Use the NPV Calculator
There are three inputs to fill in, and the result appears automatically. Here's what each field means.
- 1
Initial Investment
The amount you spend to start the project, entered as a negative number because it's cash leaving your hands. If you're putting $47,500 into a new location, type -47500. If the project has no upfront cost (unusual, but possible), enter 0.
- 2
Discount Rate
The annual rate that represents your required return or cost of capital. It's the threshold your project needs to clear. If you can earn 8% from other investments with similar risk, use 8%. If you're borrowing money at 6%, use at least 6%.
- 3
Annual Cash Flows (Year 1 onward)
Enter one value per year: what the project actually puts in your pocket each year, after costs. Positive numbers are inflows, negative numbers are additional outflows. You can add as many years as your project runs. You can also remove any row you don't need.
Worked Example: James expands his café
James is weighing up whether to open a second location. The fit-out and first-month working capital will cost $47,500. He projects net cash flows of $12,800 in Year 1, $16,350 in Year 2, $19,700 in Year 3, and $21,240 in Year 4. His cost of capital is 8%.
Initial Investment
-$47,500
Discount Rate
8%
Year 1
$12,800
Year 2
$16,350
Year 3
$19,700
Year 4
$21,240
The calculator returns an NPV of +$9,622.46 and a profitability index of 1.20. NPV is positive, so the project clears his 8% hurdle rate and is worth taking. And the discounted payback period is 3.38 years. James recoups every discounted dollar in about three years and five months.
What Is Net Present Value?
Say James gets two envelopes today. Envelope A contains $10,000 in cash. Envelope B is a promise that someone will hand him $10,000 exactly four years from now. Both say $10,000 on them, but they're not worth the same thing. If James takes the cash today and invests it at 8%, he'll have roughly $13,605 in four years. The promise in Envelope B is worth less than the money in Envelope A, even though both have the same face value.
That's the time value of money. Net present value takes that idea and applies it to an entire project's cash flow stream. It converts every future cash flow into what it's worth in today's dollars, adds them all up, and tells you whether the sum exceeds your upfront cost. If it does, the project creates value. If it doesn't, you're better off putting that money somewhere else.
Formally, NPV is the sum of all discounted cash flows over the project's life, where each cash flow is divided by a factor that represents how much time has passed. The discounting reflects opportunity cost: the return you're giving up by not putting your money into your next-best alternative. That next-best return is your discount rate.
So when James's NPV calculator shows +$9,622.46, it's saying: after discounting every future cash flow back to today's dollars, the project returns $9,622 more than his 8% hurdle rate demands. He's not just recovering his $47,500. He's beating his required return on top of that. Worth opening the second café.
What the NPV Result Actually Means
| NPV Result | What it tells you | Decision |
|---|---|---|
| Positive (+) | Project earns more than the discount rate demands | Accept |
| Zero (0) | Project earns exactly the required return, no more | Borderline |
| Negative (–) | Project destroys value at the given discount rate | Reject |
Apart from the accept/reject signal, the calculator also shows you the profitability index (PI). That's NPV divided by the initial investment, plus one. A PI above 1.0 confirms the project adds value, and the higher the number, the more value per dollar invested. James's PI of 1.20 means for every dollar he puts in, he gets $1.20 back in today's money. Not just $1.00. $1.20.
Besides PI and NPV, the payback period tells you how many years it takes to recover your initial investment in discounted terms. It's a useful sanity check, especially for projects with uncertain long-term cash flows. Now you know what the three main output numbers actually mean.
The NPV Formula
Here's the formula written out in full:
NPV = CF0 + CF1/(1+r)¹ + CF2/(1+r)² + ... + CFn/(1+r)ⁿ
Or equivalently: NPV = Σ [CFt / (1 + r)^t] for t = 0 to n
Variables:
- CF0Cash flow at time zero, the initial investment (usually negative)
- CFtCash flow at time period t
- rDiscount rate per period, expressed as a decimal (e.g. 8% = 0.08)
- tTime period number (1, 2, 3, ..., n)
- nTotal number of periods
Let's Calculate James's NPV by Hand
Here's where it gets interesting: every cash flow gets its own discount factor, and they get progressively smaller the further out in time they are.
Year 0: initial outlay
CF0 = -$47,500 (no discounting: divide by (1.08)^0 = 1)
PV = -$47,500.00
Year 1: discount once
$12,800 / (1.08)^1 = $12,800 / 1.0800
PV = $11,851.85
Year 2: discount twice
$16,350 / (1.08)^2 = $16,350 / 1.1664
PV = $14,019.33
Year 3: discount three times
$19,700 / (1.08)^3 = $19,700 / 1.2597
PV = $15,638.64
Year 4: discount four times
$21,240 / (1.08)^4 = $21,240 / 1.3605
PV = $15,612.64
Sum all present values
-$47,500.00 + $11,851.85 + $14,019.33 + $15,638.64 + $15,612.64
NPV = +$9,622.46
And just like that, James knows his second café clears the 8% bar by $9,622.46. The raw undiscounted profit from those four years is $22,590. But after discounting, only $9,622 of that is genuine value above his required return. Not the same number, not even close. Of course, you can skip all this counting and let the NPV calculator do it instantly.
Real-World Applications
Business expansion decisions
Maria runs a printing company and is deciding whether to buy a new digital press for $83,000. Her sales team projects it'll generate $28,400 in net cash each year for four years before it needs replacing. Her cost of capital is 9%. She runs the numbers through the calculator and gets an NPV of $8,317, enough to say yes. Without discounting, the raw $113,600 in projected income looks impressive. With discounting, the margin is tighter, and she knows it. That's the difference between feeling confident and being confident.
Rental property investment
Consider a landlord who wants to know whether buying a flat for $215,000, renting it out for eight years, and then selling it is actually worth the hassle at a 7% discount rate. NPV handles every one of those cash flows, including the lump-sum exit proceeds as a large positive value in Year 8. Two minutes, one clear number. 📊
Should you retrain or stay in your current job?
Kevin is a teacher considering a 12-month coding bootcamp that costs $14,750 in fees and roughly $31,000 in lost income while he studies. That's a $45,750 initial investment in human capital. He estimates his salary will rise by $18,000 per year for the first five years after qualifying. At a personal discount rate of 6%, the NPV is solidly positive. The bootcamp pays off in discounted terms. Totally worth running the numbers before handing in your notice.
Comparing two projects with the same budget
When two projects cost the same upfront, pick the one with the higher NPV. IRR and payback period can both mislead you when cash flow timing differs. NPV doesn't. It's the one metric that respects the time value of every single cash flow, not just the total.
The Most Common NPV Mistake
Here's where most people get confused about NPV: they pick a discount rate that feels right rather than one that reflects actual opportunity cost. Someone uses 3% because that's the savings rate they see advertised, even though they're funding the project with business profits that could otherwise pay down a loan at 7.5%.
Let's look at how much this matters using James's café. At 8% his NPV is +$9,622. At 12% it drops to +$1,743. At 14% it flips negative at -$1,914. The project goes from clearly worthwhile to a loss depending on which discount rate you choose (yes, really). Same cash flows, same investment, three completely different decisions.
Note that there's no single correct discount rate for everyone. If you're using personal savings, try your expected investment return. If you're borrowing, use your cost of borrowing. If you're evaluating a business project, use your weighted average cost of capital or your target return rate. But do not default to whatever number feels comfortable.
That's why the discount rate field is the most important input in the whole calculator. Get that right and the rest of the math takes care of itself.
FAQs
What discount rate should I use for NPV?
Use the rate that represents what your money could earn if you didn't do this project. That's your opportunity cost. Common choices: your weighted average cost of capital (WACC) for business investments, your borrowing rate if you're taking out a loan, or your expected portfolio return if you're choosing between investing and a personal project. Don't just pick a round number like 10% without thinking about it. The discount rate shapes every output you see.
What does a positive NPV mean?
It means the project earns more than your discount rate demands, in today's dollars. It's not just saying the project is profitable on paper. It's saying the project beats your best alternative. James's +$9,622 doesn't mean he'll have $9,622 in his pocket at the end of Year 4. It means his investment produces $9,622 more value than he'd get by investing $47,500 elsewhere at 8% for four years.
Can NPV be negative and the project still be worth doing?
Technically yes, if the discount rate you used is too conservative or if the project has strategic value beyond its cash flows (brand building, market access, infrastructure for future projects). But financially, a negative NPV at your required return means you're paying too much for the cash flows you'll receive. You'd need a specific reason to override a negative result, and it'd better be a good one.
How is NPV different from just adding up all the cash flows?
Here's the step-by-step difference: (1) Adding raw cash flows gives you the undiscounted total. James's project totals $22,590 in raw profit. (2) NPV discounts each year's cash flow back to today using the rate (1 + r)^t. So Year 4's $21,240 becomes $15,613 in today's money. (3) When you sum the discounted values and subtract the initial investment, you get NPV. James gets $9,622, not $22,590. The gap is the cost of waiting for money that's only arriving years from now.
What is the profitability index and how do I read it?
The profitability index (PI) is just 1 plus your NPV divided by the absolute value of your initial investment. For James: 1 + ($9,622 / $47,500) = 1.20. Read it like this: PI above 1 means the project adds value, PI below 1 means it doesn't, and a PI of 1.20 means you get $1.20 in present-value terms for every $1.00 you put in. It's handy when you're comparing two projects of different sizes, because a $5,000 NPV on a $10,000 project (PI = 1.50) is much better than a $5,000 NPV on a $200,000 project (PI = 1.025).
Related calculators: IRR Calculator · MIRR Calculator · TVM Calculator