NPV Calculator Guide: Net Present Value Explained (2026)

What Is Net Present Value?

Net Present Value (NPV) is the single most important concept in capital budgeting. It answers one question: after accounting for the cost of capital, does this investment create or destroy value?

The core idea is the time value of money. A dollar today is worth more than a dollar in five years because today’s dollar can be invested and grow. NPV takes every future cash flow a project will generate, discounts each one back to its present value, and then subtracts the initial investment. If the result is positive, the project returns more than your required rate — it creates value. Negative NPV means the opposite.

According to the CFA Institute, NPV is the gold standard for evaluating capital investments because it directly measures value creation in absolute dollar terms, accounts for the time value of money, and assumes reinvestment at the cost of capital — a far more realistic assumption than IRR’s implicit reinvestment rate. A 2023 survey of S&P 500 CFOs by McKinsey & Company found that 84% of large companies use NPV as a primary or secondary capital allocation tool, with NPV consistently ranking alongside IRR as the most used evaluation method.

The NPV Formula

The formula for NPV is:

NPV = ∑ [CFₙ ÷ (1 + r)^t] − Initial Investment

Where:

• CFₙ = cash flow in period t
• r = discount rate (your required rate of return)
• t = time period (year 1, year 2, etc.)
• ∑ = sum across all periods

Each cash flow gets divided by (1 + r) raised to the power of its time period. A cash flow in year 3 is divided by (1 + r)^3. This shrinks distant cash flows more than near-term ones, reflecting the reality that money further in the future is worth less today.

Step-by-Step: How to Calculate NPV

Here’s the process broken down into four steps:

1. Identify all cash flows. List the initial investment (negative cash flow at year 0) and every projected cash inflow and outflow over the project’s life. Include terminal value or salvage value in the final year if applicable.
2. Choose your discount rate. This is your required rate of return. Use WACC for corporate projects, your hurdle rate for private equity, or the risk-free rate plus a risk premium for individual investments. More on this below.
3. Discount each cash flow. Divide each period’s cash flow by (1 + r)^t, where t is the year number. Year 1 gets divided by (1 + r)^1, year 2 by (1 + r)^2, and so on.
4. Sum and subtract. Add all discounted cash flows together, then subtract the initial investment. The result is NPV.

Worked Example: 5-Year Manufacturing Project

Say you’re evaluating a $200,000 equipment purchase for a manufacturing operation. The project is expected to run 5 years with the following annual cash flows. Your company’s WACC is 10%.

The NPV is +$29,578. This project should be approved — it creates $29,578 of value above and beyond the 10% required return on the $200,000 investment.

To verify year 1: $45,000 ÷ (1.10)^1 = $45,000 ÷ 1.10 = $40,909. Year 3: $65,000 ÷ (1.10)^3 = $65,000 ÷ 1.331 = $48,835.

Choosing the Right Discount Rate (WACC, Hurdle Rate, Risk-Free Rate)

The discount rate is the most judgment-intensive input in any NPV calculation. Get it wrong and you’ll approve projects you should reject — or reject ones you should approve.

WACC for Corporate Capital Budgeting

Weighted Average Cost of Capital (WACC) blends the after-tax cost of debt and equity, weighted by how much of each a company uses to finance itself. A company that’s 60% equity (cost: 12%) and 40% debt (after-tax cost: 4%) has a WACC of (0.6 × 12%) + (0.4 × 4%) = 8.8%. According to McKinsey’s Capital Allocation research, the average S&P 500 company WACC in 2024 ranged from 7% to 11% depending on industry, with capital-intensive sectors like utilities at the low end and technology at the high end.

Hurdle Rates for Private Equity

Private equity and venture capital firms use a hurdle rate — the minimum acceptable return before carried interest kicks in. Industry data from Preqin shows that buyout funds typically set hurdle rates at 8% for preferred returns, but internal project evaluation commonly uses hurdle rates of 15–25% to account for illiquidity, leverage, and execution risk. If a deal can’t clear a 20% IRR threshold with an NPV > 0 at that discount rate, it typically doesn’t get funded.

Risk-Free Rate Plus Risk Premium

Individual investors and smaller businesses without a calculated WACC often start with the 10-year Treasury yield (the risk-free rate) and add a risk premium based on project uncertainty. Low-risk, stable cash flows: add 2–4%. Moderate uncertainty: add 5–8%. High-risk ventures: add 10%+. As of early 2026, with the 10-year Treasury around 4.5%, a moderate-risk small business investment might use a discount rate of 10–12%.

NPV vs IRR: Which Should You Use?

This is the most common question in capital budgeting. The short answer: use both, but trust NPV when they conflict.

IRR fails in two important scenarios. First, it can produce multiple solutions when cash flows switch sign more than once (e.g., a project that has outflows in the middle years). Second, it ignores scale — a $1,000 investment returning 50% IRR is worse than a $1,000,000 investment returning 20% IRR if you have the capital to deploy. A 2022 Harvard Business Review analysis of capital budgeting surveys found that 75% of Fortune 500 CFOs use IRR as their primary metricdespite its theoretical weaknesses, primarily because it’s easier to present to boards. Best practice: calculate both, present IRR to stakeholders, but base the final go/no-go on NPV.

5 Common NPV Calculation Mistakes

1. Using the Wrong Discount Rate

The single biggest source of NPV errors. Using a company’s overall WACC to evaluate a high-risk venture project will inflate NPV and lead to bad approvals. Each project should be discounted at a rate that reflects its own risk profile, not the firm’s average.

2. Forgetting Working Capital Changes

Many analysts include revenue and EBITDA projections but omit working capital requirements — inventory build, receivables growth, and payables. Growing businesses often require significant cash investment in working capital that reduces actual free cash flow well below accounting profit. The cash flow that matters for NPV is free cash flow, not net income.

3. Ignoring Terminal Value

For long-lived assets or businesses, a significant portion of NPV often comes from terminal value — the value of cash flows beyond the explicit forecast period. A common approach is to apply a perpetuity formula: Terminal Value = Final Year Cash Flow × (1 + growth rate) ÷ (discount rate − growth rate). Leaving this out dramatically understates NPV for ongoing operations.

4. Optimism Bias in Cash Flow Forecasts

According to research published in the Journal of Finance, capital project cash flows are systematically overstated by 20–40% due to optimism bias. The antidote is scenario analysis: run a base case, a downside case (30–40% lower revenues, 10–15% higher costs), and check whether NPV is still positive under the downside. If the project only works under rosy assumptions, treat it as a red flag.

5. Ignoring Opportunity Cost

The discount rate in NPV implicitly accounts for opportunity cost — what you could earn elsewhere at the same risk level. But analysts sometimes evaluate projects in isolation without asking: “What else could we do with this capital?” If you have three projects with positive NPVs but limited capital, rank them and allocate accordingly. NPV-positive alone isn’t enough if better alternatives exist.

How NPV Is Used in Real Investment Decisions

NPV shows up across virtually every major investment context:

• Corporate capital budgeting: Equipment purchases, factory expansions, product launches, R&D projects. A Deloitte survey of global CFOs found that companies spending more than $100M annually on capex almost universally require an NPV analysis with sensitivity testing before board approval.
• Mergers & acquisitions: Acquirers model projected synergies as incremental cash flows, discount them at WACC, and the resulting NPV tells them the maximum premium they can pay while still creating shareholder value.
• Real estate investment: Investors calculate NPV of rental income streams discounted at their required cap rate or yield to determine whether a property is priced fairly relative to the cash it will generate.
• Startup fundraising: VCs and growth equity investors implicitly run NPV analysis when building DCF models to back-test whether a proposed valuation makes sense given projected revenue and margin trajectories.
• Personal finance: Decisions like buying vs. leasing a car, refinancing a mortgage, or going back to school can all be modeled as NPV problems — compare the NPV of each option’s cash flows and choose the higher one.

Frequently Asked Questions

What is Net Present Value (NPV)?

Net Present Value (NPV) is the sum of all future cash flows from an investment, each discounted back to today’s dollars, minus the initial investment. A positive NPV means the investment is expected to generate more value than it costs, accounting for the time value of money. NPV is the most theoretically sound capital budgeting method because it directly measures value creation in dollar terms.

What does a positive NPV mean?

A positive NPV means the investment is expected to return more than your required rate of return (discount rate). Every dollar of positive NPV represents value created above and beyond the cost of capital. The decision rule is simple: invest when NPV > 0, reject when NPV < 0. If comparing mutually exclusive projects, choose the one with the higher positive NPV.

How do you choose a discount rate for NPV?

The discount rate depends on your situation. Corporations typically use WACC (Weighted Average Cost of Capital), which blends the after-tax cost of debt and equity. Private equity firms use a hurdle rate — often 15–25% — that reflects their target return. Individual investors often use the risk-free rate (10-year Treasury yield) plus a risk premium of 3–8% depending on project risk. The higher the risk, the higher the discount rate you should apply.

What is the difference between NPV and IRR?

NPV tells you the dollar value an investment adds (or destroys) in today’s terms. IRR tells you the rate of return at which NPV equals zero. NPV is theoretically superior because it accounts for the scale of investment and assumes cash flows are reinvested at the cost of capital. IRR is more intuitive and widely used because finance teams can quickly say “this project returns 24%” without needing to agree on a discount rate. When NPV and IRR disagree on project rankings, always trust NPV.

When is IRR better than NPV?

IRR is better than NPV in two specific cases: (1) when you’re communicating investment returns to stakeholders who find percentages easier to interpret than dollar values, and (2) when comparing projects of very different sizes where a percentage return is more meaningful than an absolute dollar figure. IRR is also useful as a quick screen — if a project’s IRR is below your cost of capital, it’s automatically rejected without needing to calculate a full NPV.

Can NPV be negative and the investment still be worth making?

In purely financial terms, no. A negative NPV means the project destroys value after accounting for the cost of capital. However, some investments with negative NPVs are made for strategic reasons — regulatory compliance, brand positioning, or options value (the project creates a foothold for future opportunities). When this happens, the negative NPV is the explicit cost of that strategic benefit. Good capital allocation practice is to quantify that cost clearly rather than manipulating the discount rate to force a positive result.