Net Present Value (NPV) Calculator

Net present value tells you what a project is worth today, in cash, after paying for the money it ties up. Enter the up-front outlay, the cash each future period brings in, and the return you require, and this calculator discounts every flow back to period zero and nets them against the outlay. A positive NPV means the project clears your required return and adds that much value; a negative NPV means it destroys value. You also get the profitability index, the internal rate of return, a period-by-period discounting schedule, and an NPV profile showing how the answer moves as the discount rate changes.

Calculator

This calculator runs in your browser. Enable JavaScript for live results — the inputs, formula and worked example below remain fully readable without it.

Inputs this calculator takes, with typical values
InputWhat to enterExample
Initial investment at t = 0The cash you commit before the project starts. Enter it as a positive number; it is treated as an outflow.100000 $
Discount rate (required return per period)Usually your weighted average cost of capital, or the return the project must beat to be worth funding.10 %
Cash flow for each period after t = 0One net cash flow per period, separated by commas. Put a minus sign in front of any period that is a net outflow.30000, 35000, 40000, 45000, 50000
Amounts are inApplies to the outlay and to every cash flow you type. Results are always shown in whole dollars.Dollars
Salvage or terminal valueAdded to the last period's cash flow. Use it for resale proceeds, working-capital release, or a decommissioning cost entered as a negative.0 $
Use the mid-year discounting conventionDiscounts each period over t − 0.5 instead of t, which assumes cash arrives evenly through the period rather than all on the final day.No

It returns

  • Net present value — Value added today, in dollars, over and above the return you demanded.
  • Present value of future cash flows
  • Profitability index (PV ÷ outlay)
  • Internal rate of return
  • Sum of cash flows, undiscounted
  • Periods detected

The formula

NPV=C0+t=1nCFt(1+r)t
PI=PV of inflowsC0=1+NPVC0

In plain text: NPV = −C₀ + Σ(t=1..n) CFₜ / (1 + r)^t

  • NPVNet present value — value added today ($)
  • C₀Cash outlay at time zero ($)
  • CFₜNet cash flow in period t ($)
  • rRequired return per period, as a decimal (decimal)
  • nNumber of periods in the forecast (periods)
  • tPeriod index, counted from the outlay (periods)

Cash flows are assumed to arrive at the end of each period unless you switch on the mid-year convention, which discounts over t − 0.5 instead.

Updated Category Capital Budgeting & Project Appraisal Verified against published test cases Reading time 12 min

What net present value actually measures

NPV is the amount of value a project creates after paying for the capital it consumes. It is denominated in today's dollars, and it is additive: the NPV of two independent projects is the sum of their NPVs. No other capital budgeting measure has both properties, which is why NPV is the rule finance theory endorses and the one every other rule gets compared against.

The logic runs in three moves. A dollar arriving in five years is worth less than a dollar today, because today's dollar can be invested. The rate at which you trade future dollars for present ones is your required return, r. So you shrink each future flow by 1 ÷ (1 + r)t, add the shrunken values, and subtract what you pay now.

That surplus has a concrete meaning. An NPV of $48,000 says the project pays back its cost, earns your required return on the capital while it is tied up, and still leaves $48,000 of extra value in today's money. An NPV of −$12,000 says the project earns something, just not enough.

The decision rule is therefore blunt. Accept every independent project with a positive NPV, reject every negative one, and when capital is rationed rank by value created per dollar committed rather than by NPV alone.

Why the formula discounts each period separately

Each cash flow gets its own discount factor because each one waits a different length of time. The factor for period t is (1 + r)−t, the present value of $1 received t periods from now. At 10% that factor is 0.9091 after one period, 0.6209 after five and 0.3855 after ten: the same dollar loses about 61% of its present value over a decade.

Three details in the formula do most of the work in practice.

The rate must match the period. If your cash flows are quarterly, r is a quarterly rate: a 12% annual rate becomes 1.120.25 − 1 = 2.874% per quarter when compounding. Mixing an annual rate with quarterly flows overstates NPV badly.

The rate must match the risk of the cash flows, not the source of the money. A firm with cheap debt does not get to discount a risky project at its borrowing rate. The discount rate belongs to the project. Build it from the weighted average cost of capital of a business with the same risk profile, and use CAPM for the equity leg.

Cash flows are cash, not accounting profit. Add depreciation back, subtract capital expenditure and the change in working capital, use after-tax operating numbers, exclude interest (the discount rate already charges for financing), and ignore sunk costs entirely. Include opportunity costs and any incremental effect on other product lines. The free cash flow to the firm definition is the one to work from.

Because the discount factor shrinks geometrically, cutting the forecast at year five throws away everything after it — which is why most valuation models bolt on a terminal value to represent the tail.

Worked example: a $100,000 machine with five uneven years

A plant manager wants to buy a $100,000 packaging line. After-tax cash flows are forecast at $30,000, $35,000, $40,000, $45,000 and $50,000 over five years. The company's cost of capital is 10%. Work it through period by period.

  1. Convert the rate. r = 10 ÷ 100 = 0.10 per year.
  2. Year 1. Factor = 1 ÷ 1.10 = 0.909091. PV = $30,000 × 0.909091 = $27,272.73.
  3. Year 2. 1.102 = 1.21, factor = 0.826446. PV = $35,000 × 0.826446 = $28,925.62.
  4. Year 3. 1.103 = 1.331, factor = 0.751315. PV = $40,000 × 0.751315 = $30,052.59.
  5. Year 4. 1.104 = 1.4641, factor = 0.683013. PV = $45,000 × 0.683013 = $30,735.61.
  6. Year 5. 1.105 = 1.61051, factor = 0.620921. PV = $50,000 × 0.620921 = $31,046.07.
  7. Add the present values. 27,272.73 + 28,925.62 + 30,052.59 + 30,735.61 + 31,046.07 = $148,032.61.
  8. Subtract the outlay. $148,032.61 − $100,000 = NPV of $48,032.61.

Two checks fall out of the same numbers. The undiscounted flows total $200,000, so discounting removed $51,967 of apparent profit — the cost of waiting. And the profitability index is $148,032.61 ÷ $100,000 = 1.4803, so every dollar committed comes back as $1.48 of present value. The rate at which NPV would cross zero is the internal rate of return, 25.75% here; the gap to the 10% hurdle is the project's margin of safety on the discount rate.

How to read the number you get

Read the sign first, then the size relative to the outlay, then the sensitivity.

The sign is the decision. Positive means accept, negative means reject, and there is no threshold beyond zero — NPV is already net of your required return, so a $500 NPV on a $10m project is technically an accept. In practice a result that close to zero is inside the noise of your own forecast and should be treated as a coin flip, not a green light.

The size only means something relative to the money at risk. Use the profitability index for that. A PI of 1.48 is strong; 1.05 is marginal; below 1.00 the project destroys value. When you are choosing among projects that compete for the same limited budget, rank by PI and fill the budget from the top — that produces more total NPV than ranking by NPV when capital binds.

Sensitivity tells you how much to trust it. The NPV profile chart plots NPV against the discount rate. A steep profile means the answer is dominated by distant cash flows and is fragile to the rate you picked. Recompute at your hurdle rate ±3 percentage points and shave 20% off the last two forecast years; if NPV survives both, the accept decision is robust.

Two figures deserve equal weight next to NPV. The internal rate of return converts the surplus into a rate, which is easier to compare against a hurdle. The discounted payback period tells you how long your capital is exposed before it is recovered in present-value terms.

Present value of $1 received in period t

Multiply a cash flow by the factor for its period and rate. A $40,000 flow in year 3 at 10%: 40,000 × 0.7513 = $30,052.
Period5%8%10%12%15%
10.95240.92590.90910.89290.8696
20.90700.85730.82640.79720.7561
30.86380.79380.75130.71180.6575
40.82270.73500.68300.63550.5718
50.78350.68060.62090.56740.4972
100.61390.46320.38550.32200.2472
150.48100.31520.23940.18270.1229
200.37690.21450.14860.10370.0611

Each factor is (1 + r)⁻ᵗ, rounded to four places. Notice the 20-year row: at 15% a dollar two decades out is worth six cents, which is why long-dated forecasts contribute almost nothing to NPV at high discount rates.

Where the discount rate comes from

For a project with the same risk as the firm's existing business, use the after-tax weighted average cost of capital. For a project that is riskier or safer than the firm, use the WACC of a pure-play comparable — unlever its beta, relever at your own capital structure, and rebuild the rate. Never use the interest rate on the loan that happens to fund the project.

Public-sector work in the United States follows OMB Circular A-94, which prescribes the discount rates for federal benefit-cost analysis and requires real rates applied to real cash flows. Whatever rate you pick, keep it consistent with the flows: nominal with nominal, real with real.

Mistakes that make an NPV wrong

  • Discounting profit instead of cash. Net income contains depreciation, accruals and non-cash charges. Convert to free cash flow first: after-tax operating profit, plus depreciation, minus capital expenditure, minus the increase in working capital.
  • Subtracting interest from the cash flows. The discount rate already prices financing. Charging interest as well double-counts the cost of capital and understates NPV.
  • Mixing nominal and real. A 10% nominal rate applied to cash flows held flat in today's prices silently assumes zero inflation and biases every long-dated project toward rejection.
  • Including sunk costs, or ignoring working-capital release. The feasibility study you already paid for is irrelevant; only incremental future cash matters. But inventory and receivables tied up at the start do come back at the end, so put that recovery in the final period.
  • Truncating the forecast without a terminal value. Stopping at year five implicitly assumes the asset is worthless afterwards. Either add salvage value or extend the horizon.
  • Reading NPV as a return. It is a dollar amount, not a rate, and it scales with project size. Compare projects of different sizes on profitability index, never on raw NPV.

NPV against IRR, payback and the profitability index

Every alternative rule is a shortcut that fails in an identifiable way, and knowing the failure mode tells you when the shortcut is safe.

IRR answers the same question as a rate rather than a dollar amount, which makes it far easier to communicate. It matches NPV's verdict for a conventional stream — one outflow followed by inflows. It breaks in three cases: streams that change sign more than once can have several IRRs or none; ranking mutually exclusive projects by IRR can pick the smaller one; and IRR implicitly assumes intermediate cash flows are reinvested at the IRR itself. The MIRR fixes that last assumption explicitly.

Payback ignores the time value of money and everything after recovery, so it is a liquidity screen rather than a value measure. It still earns its place: just over half the CFOs in Graham and Harvey's survey of corporate practice reported using it. Use the payback period calculator for the raw version.

Profitability index is NPV per dollar of outlay. It is the right ranking tool under capital rationing and gives the same accept/reject answer as NPV for a standalone project, because PI > 1 and NPV > 0 are the same statement.

Most finance teams settle on the same protocol: compute NPV as the decision, quote IRR as the headline, check payback as a risk screen, rank by profitability index when the budget binds. When cash flows arrive on irregular calendar dates, switch to a date-aware method such as XIRR rather than forcing them into equal periods.

Key terms

Discount factor
The present value of $1 received in period t, equal to (1 + r)−t. Multiply a cash flow by it to move the money back to today.
Free cash flow
Cash available to all investors after taxes and reinvestment: after-tax operating profit plus depreciation, less capital expenditure and less the increase in working capital. This is what belongs in an NPV, not net income.
Hurdle rate
The minimum return a project must earn to be funded. Usually the cost of capital, sometimes the cost of capital plus a management premium for optimism in the forecasts.
Profitability index
Present value of the inflows divided by the initial outlay, equal to 1 + NPV ÷ C₀. Ranks projects by value created per dollar committed.
NPV profile
A plot of NPV against the discount rate. Its intercept on the horizontal axis is the IRR, and its steepness shows how sensitive the project is to the rate you assume.

Frequently asked questions

Should I enter the initial investment as a negative number?

No. Enter it as a positive number in the Initial investment field; the calculator subtracts it. Only use minus signs inside the cash flow list, for periods that are net outflows — a mid-project overhaul or a second construction phase. Those periods are discounted like any other flow, and the calculator flags that the accompanying IRR may not be unique when they are present.

What discount rate should I use if I do not know my cost of capital?

Start with the return you could earn on a comparable-risk alternative, then bracket it. Rather than guessing a single number, run the calculation at three rates — say 8%, 12% and 16% — and see whether the accept/reject verdict changes. If it does not, you do not need a precise rate. If it does, build one properly: take the cost of equity from CAPM, take your after-tax cost of debt from the rate on your own borrowings, and weight them in the WACC calculator. Damodaran publishes cost-of-capital figures by industry each year if you need a starting comparable rather than an invented one.

Why is my NPV different from Excel's NPV function?

Because Excel's NPV discounts the first value in the range by one period. If you include the outlay inside the range, Excel discounts it too, which is wrong. The standard fix is =NPV(rate, CF1:CFn) - C0, keeping the outlay outside the function. This calculator follows that convention: the outlay sits at period 0 undiscounted, and the cash flow list starts at period 1.

Can NPV be positive while IRR is below my hurdle rate?

Not for a conventional stream discounted at that same hurdle rate — the two rules agree by construction, because NPV is positive exactly when the rate that zeroes it is above the rate you used. If they disagree, something structural is going on: multiple sign changes in the cash flows, more than one IRR, or a comparison between projects of different size or life. In all those cases trust the NPV.

How many years should I forecast?

As far as you can defend the cash flows, then put a value on everything after that. For equipment, use the asset's economic life and include resale proceeds in the final period. For a business, five to ten explicit years plus a terminal value is standard practice. Extending a forecast to twenty years to make NPV positive is self-deception: at 12% a dollar in year 20 is worth ten cents.

Does NPV handle a project whose cash flows go negative in the middle?

Yes, and this is where NPV beats IRR. Type the negative period into the cash flow list with a minus sign and it is discounted like any other flow; the arithmetic does not care about the sign pattern. IRR does care — a stream that changes sign more than once can have several internal rates of return, so the calculator warns you when it detects interim outflows.

What NPV is good enough to approve a project?

Any positive NPV clears the theoretical bar, but most capital committees want a cushion because forecasts run optimistic. A common working rule is to require NPV to stay positive after cutting the cash flows by 20% and raising the discount rate by 3 percentage points. The first half of that test is exact arithmetic: cutting every inflow by 20% multiplies the present value by 0.8, so the project only survives if the profitability index was above 1 ÷ 0.8 = 1.25 to begin with. Raising the rate as well pushes the required starting index higher again, and how much higher depends on how far out the cash flows sit.

Should the cash flows be before or after tax?

After tax, always, and the discount rate must be after tax too. Compute taxes on operating profit as if the project carried no debt, then add depreciation back as a non-cash item — the tax it shelters is a genuine cash benefit. Using a pre-tax rate with after-tax cash flows will make you reject good projects.

References

  • Principles of Corporate Finance, 13th ed. — Chapters 5–6, Net Present Value and Investment Decisions — McGraw-Hill (Brealey, Myers & Allen)
  • Circular A-94: Guidelines and Discount Rates for Benefit-Cost Analysis of Federal Programs — U.S. Office of Management and Budget
  • Investment Valuation, 3rd ed. — Wiley (Aswath Damodaran)
  • The Theory and Practice of Corporate Finance: Evidence from the Field, Journal of Financial Economics 60 (2001) — Elsevier (John Graham & Campbell Harvey)
  • CFA Program Curriculum — Corporate Issuers: Capital Budgeting — CFA Institute