NPV Calculator

Calculate Net Present Value (NPV) and Profitability Index for corporate capital investments and projects.

Evaluate capital expenditure projects, acquisitions, and equipment investments using discounted cash flow analysis. Input initial cash outlay, your weighted average cost of capital (WACC) discount rate, and expected annual cash flows to determine project viability.

How this calculator works

NPV = Sum of [ Cash Flow_t / (1 + r)^t ] for t=1..n - Initial Outlay. Profitability Index = Present Value of Inflows / Initial Outlay.

Key benefits

Assumptions & exclusions

Frequently asked questions

Why is NPV preferred over simple payback period?

NPV accounts for the time value of money and all future cash flows throughout the entire project lifecycle, whereas simple payback ignores the cost of capital and all profits earned after the break-even date.

What discount rate should I use for NPV?

Use the return you require for tying up capital in this project: typically your borrowing cost or your weighted average cost of capital, raised for risky projects. If your capital costs 7% and similar investments return 9%, a rate below that range needs a specific justification.

What does a negative NPV actually mean?

It means the project's discounted inflows fall short of its cost at your required rate — the project still might return more cash than it consumes in raw dollars, but not enough to compensate you for the wait and the risk at the rate you demanded.

Can I use NPV to compare projects of different sizes?

Carefully. NPV measures total value added in dollars, so a large project can show a bigger NPV while using far more capital. When funds are limited, also compare the profitability index — present value per dollar invested — before deciding which project deserves the money.

Should I include taxes and depreciation in the cash flows?

Include the cash effects: taxes the project causes are outflows, and depreciation matters only through the tax shield it creates. The investment itself and any later overhauls or disposal costs belong in the year they occur, entered as negative amounts in those years.

What is the profitability index and when is it useful?

It is the present value of future inflows divided by the initial investment. Above 1.0 matches a positive NPV. It is most useful when several worthwhile projects compete for limited capital, because it ranks value created per dollar committed rather than total dollars created.

Formula-Based Calculator · By QalcTools Editorial Team. Formulas tested against independent reference values · Content reviewed November 2026 by the QalcTools Editorial Team.

Methodology note: Corporate Capital Budgeting and Discounted Cash Flow (DCF) theory.

Related calculators

Category: Business & Commercial Calculators

About this calculator

A project can return more cash than it costs and still be a bad investment, because money arriving in five years is worth less than money today. Net present value fixes that comparison: it discounts every expected future cash flow back to today’s dollars and subtracts the initial outlay. This calculator takes your upfront investment, your discount rate, and up to five years of expected inflows, then returns the NPV, the total undiscounted cash, and a profitability index. A positive result means the project clears your required return under your assumptions — the starting point, not the end, of a capital decision.

How it works

Enter the initial investment as a positive amount, choose a discount rate that reflects your cost of capital or required return, and fill in the cash inflow you expect in each year. The tool divides each year’s inflow by one plus the rate raised to that year’s number, so later money is shrunk more than earlier money, and sums those discounted values. It subtracts the initial investment to produce NPV, and divides the discounted inflows by the investment for the profitability index. The verdict follows the sign: at or above zero the project earns at least your required rate; below zero it falls short.

The formula, explained

NPV = CF1 ÷ (1 + r)^1 + CF2 ÷ (1 + r)^2 + … + CFn ÷ (1 + r)^n − Initial investment; PI = PV of inflows ÷ Initial investment

The engine floors the initial investment at zero and converts the discount rate from a percent to a decimal, defaulting to 10 percent if the field is empty. It then walks the cash-flow list in order, discounting the first entry by one year, the second by two, and so on — every flow is treated as arriving at the end of its year, with no mid-year adjustment. It sums the nominal flows separately so you can see the discounting effect, computes NPV as discounted inflows minus the investment, rounded to cents, and sets the profitability index to discounted inflows divided by the investment. The profitable flag is simply NPV at or above zero.

Inputs and variables

VariableMeaningExample
Initial InvestmentThe cash you commit at the start — equipment, buildout, acquisition price and any immediate working capital the project needs to launch.$80,000
Discount Rate (%)The annual return you require to justify tying money up in this project instead of the next-best use. Higher rates punish distant cash flows more heavily.8%
Yearly Cash InflowsThe net cash the project is expected to generate in each year, after its running costs but in the order the years occur. Later years are discounted more.$20,000 in year 1 rising to $30,000
Profitability Index (output)Present value of inflows per dollar invested. A PI of 1.29 means each dollar committed is expected to create about $1.29 of present value.1.29

Worked example

A business considers an $80,000 equipment investment expected to return $20,000, $25,000, $30,000, $30,000 and $25,000 over five years, using an 8 percent discount rate.

  1. Discount each inflow at 8%: year 1 $20,000 ÷ 1.08 ≈ $18,519; year 2 $25,000 ÷ 1.08^2 ≈ $21,433; year 3 $30,000 ÷ 1.08^3 ≈ $23,815; year 4 $30,000 ÷ 1.08^4 ≈ $22,051; year 5 $25,000 ÷ 1.08^5 ≈ $17,015.
  2. Present value of all inflows: about $102,832, against $130,000 of undiscounted cash — discounting removes roughly $27,168 of time value.
  3. NPV: $102,832 − $80,000 = $22,832.43.
  4. Profitability index: $102,832 ÷ $80,000 ≈ 1.29.

An NPV of +$22,832.43, a profitability index of 1.29, and $130,000 of total nominal cash flows on an $80,000 investment — the project clears the 8 percent hurdle.

The positive NPV says that, if the forecasts hold, this project pays back its cost, covers an 8 percent annual required return on the money tied up, and adds about $22,832 of value in today’s dollars on top. The PI of 1.29 is the figure to compare if a rival project also shows a positive NPV but needs a different amount of capital. The sensitivity to test before committing is the discount rate: rerun at 12 percent and with year-4 and year-5 flows trimmed, and see whether the verdict survives less friendly assumptions.

Understanding your results

Compare NPV with the nominal total to see what time is costing you. In the example, $130,000 of raw inflows shrink to about $102,832 of present value — that gap is the price of waiting, and it grows quickly with the discount rate and the project’s length. Two projects with identical nominal totals can have very different NPVs if one pays early and the other pays late, which is exactly the distinction a simple payback calculation hides.

Use NPV to rank, not just to accept. When capital is limited, the project with the highest NPV per dollar committed — reflected in the profitability index — usually deserves the funds first. And treat the discount rate as an opinion you are responsible for: it should reflect what your capital costs and what else it could earn, not a number chosen to make a favorite project pass.

Assumptions and limitations

NPV is only as honest as the cash-flow forecasts and the discount rate you feed it, and this engine applies both mechanically. It treats each inflow as a single end-of-year amount, applies one constant discount rate to every year, and includes no taxes, financing structure, salvage value or follow-on investment unless you build them into the yearly figures yourself. It cannot weigh risks that do not show up in the numbers, such as a key customer leaving in year two. Run at least one pessimistic case — lower flows, higher rate — and require the project to look acceptable there too before treating a positive result as a decision.

Common mistakes to avoid

Sources

Related guides