Net Present Value (NPV)
Understand what Net Present Value means, how to calculate it, and how to use it to make better investment decisions.
Track all your Financial KPIs in one place
Sign up for free and start making decisions for your business with confidence.
Net Present Value (NPV) is a financial metric that measures the current worth of future cash flows from an investment, minus the initial cost. A positive NPV means the investment is expected to generate more value than it costs, and gives you a clear signal on whether to proceed.
Businesses use NPV to evaluate projects, compare investment options, and decide where to allocate capital. By converting future cash flows into today's dollars, NPV gives you a consistent basis for comparison, regardless of timeline or scale.
What is Net Present Value (NPV)?
Net Present Value (NPV) is the difference between the present value of future cash inflows and the cost of an initial investment, expressed in today's dollars.
NPV is built on the concept of the time value of money: a dollar today is worth more than a dollar in the future. A project that returns $110 one year from now is not equivalent to one that returns $100 today, because the future payment is worth less in present terms.
By discounting future cash flows back to today's value, NPV lets you answer a straightforward question: does this investment create value, and by how much?
What is a good Net Present Value?
A positive NPV means the project is expected to return more than it costs. That's generally a signal to proceed. A negative NPV means the opposite: the investment is expected to destroy value.
In practice, most businesses set a minimum threshold. You might only accept projects with an NPV of at least 10% above the initial investment, rather than any positive result. This margin of safety accounts for forecast uncertainty, especially on longer-horizon projects.
When comparing the NPV of two projects, choose the one with the higher value, all else being equal. Also weigh the project's risk profile and any external conditions that could affect your cash flow assumptions.
How to measure Net Present Value
To calculate NPV, you need two inputs: the initial investment and the expected cash flows for each period.
The core formula is:
NPV = -Initial Investment + ? [Cash Flow / (1 + Discount Rate)^Period]
The discount rate reflects the minimum acceptable return, often benchmarked against a risk-free investment like a government bond, or your company's cost of capital.
Example: A project requires a $3,000 initial investment and generates $1,500 per year for five years. With a discount rate of 4%, each year's cash flow is discounted back to present value:
| Year | Cash flow | Discount factor (4%) | Present value |
|---|---|---|---|
| 1 | $1,500 | 0.9615 | $1,442 |
| 2 | $1,500 | 0.9246 | $1,387 |
| 3 | $1,500 | 0.8890 | $1,334 |
| 4 | $1,500 | 0.8548 | $1,282 |
| 5 | $1,500 | 0.8219 | $1,233 |
Sum of present values: $6,678
NPV: $6,678 - $3,000 = $3,678
In plain terms: this project is expected to put $3,678 more in your pocket, in today's dollars, than the investment costs. That's a decision you can act on.
Steps to measure NPV using a spreadsheet
Most spreadsheet tools include a built-in NPV function. Here's how to use it:
- Enter the discount rate in cell A1.
- Enter the expected cash flows for each period in cells A2 through A6 (one per year).
- In a separate cell, enter the formula:
=NPV(A1, A2:A6) - Initial Investment
- The result is the NPV.
To calculate the Internal Rate of Return (IRR) from the same data, use
=IRR(A2:A6)
Net Present Value examples
Example 1 — Basic NPV:
You invest $2,000 and expect $500 in annual cash flows for five years at a 4% discount rate.
NPV = -$2,000 + ($500/1.04) + ($500/1.04²) + ... + ($500/1.04?) NPV = -$2,000 + $2,226 = $226
The project generates a modest positive return. Worth pursuing if the risk is low, and you have confidence in those cash flow estimates.
Example 2 — Comparing two projects:
Two projects each require a $2,000 investment and produce the same total cash flows, but with different timing. Project A front-loads cash flows; Project B back-loads them. At the same discount rate, Project A will have a higher NPV, because earlier cash flows are worth more in present terms. NPV makes this difference visible without you having to do the mental accounting yourself.
If the NPV of either project were negative, the investment would be expected to destroy value rather than create it.
Challenges of using NPV to make investment decisions
NPV is a powerful tool, but it depends on assumptions that may not hold.
Cash flow forecasts are uncertain. NPV is only as accurate as the inputs. Overly optimistic revenue projections or underestimated costs will inflate the result. If the numbers going in are guesses, treat the output as a range, not a verdict.
Discount rate selection matters. Choosing a rate that's too low overstates project value; too high and you'll reject projects that would have been profitable. Getting this number right requires judgment, not just calculation.
Timing affects accuracy. NPV is a time-dependent measure that assumes cash flows arrive at fixed intervals. Irregular or uncertain timing can reduce precision.
To address these limitations, pair NPV with complementary tools. Monte Carlo simulations model how uncertainty in variables like cost or timing affects outcomes. Sensitivity analysis identifies which assumptions have the most impact on the result. Risk metrics like Value at Risk (VaR) and Expected Shortfall (ES) can quantify downside exposure.
Used together, these tools give you a more complete picture of a project's risk-return profile, and more confidence in the decision you're making.
Net Present Value vs. Internal Rate of Return
NPV and Internal Rate of Return (IRR) are both used to evaluate investment returns, but they answer different questions.
| NPV | IRR | |
|---|---|---|
| What it measures | Dollar value created above the initial investment | The rate of return at which NPV equals zero |
| Output | A dollar amount | A percentage |
| Handles uneven cash flows | Yes | Yes, but can produce multiple results |
| Accounts for scale | Yes | No — a 30% return on $1,000 looks equal to 30% on $1M |
| Best for | Comparing projects with different durations or sizes | Quick return benchmarking |
NPV is generally preferred when comparing projects with different lifetimes, sizes, or risk profiles. It tells you not just whether a project clears the bar, but by how much, in dollars you can plan around. IRR is useful as a secondary check: if a project's IRR exceeds your discount rate, it clears your minimum return threshold.
Net Present Value vs. payback period
The payback period measures how long it takes to recover the initial investment from cash flows. It's simple to calculate but limited in scope.
| NPV | Payback period | |
|---|---|---|
| Time value of money | Accounted for | Ignored |
| Cash flows beyond payback | Included | Ignored |
| Risk comparison | Supports comparison | Limited |
| Output | Dollar value | Number of years |
The payback period works well for quick screening of short-duration investments. For any decision where accuracy and completeness matter, NPV is the preferred financial metric. It accounts for what happens after you break even, which is often where the real value, or risk, lives.
Tracking NPV alongside other financial metrics
A single NPV calculation is a point-in-time answer. The more useful version is knowing how your active investments are performing against their original projections, without having to pull the numbers yourself each time.
Finance teams that track NPV alongside cash flow, IRR, and return metrics in a financial dashboard catch variance earlier and spend less time explaining the same numbers to different stakeholders. Klips connects to your financial data sources and keeps those figures current, so the conversation can stay on what to do next rather than whether the numbers are right.
FAQs
What factors go into an NPV calculation?
NPV requires the initial investment amount, expected cash flows for each period, the discount rate, and the number of periods. The discount rate should reflect either your cost of capital or the return available from a comparable risk-free investment.
What are the benefits of using NPV?
NPV accounts for the time value of money, adjusts for inflation and risk through the discount rate, and produces a dollar-denominated result that's easy to interpret. It also supports direct comparison between projects with different durations or risk profiles, giving decision-makers a consistent basis for capital allocation.
When should I use the payback period instead of NPV?
Use the payback period for quick screening of low-complexity, short-duration investments where cash flow timing is predictable. For any decision requiring a full picture of returns, use NPV.
Related Metrics & KPIs
