functions

NPV Calculator | Calculate NPV From Cash Flows and Discount Rate

Q: What is net present value?

The Npv Calculator Online is free, private, and accurate: it runs entirely in your browser (no uploads, no accounts), applies the standard calculation, and explains each step so you can verify the result. Calculates npv using NPV = Σ CFₜ ÷ (1 + r)ᵗ, t = 0 … n, in real time in your browser. There is no limit on usage, and it works on any device.

Q: How do I enter the cash flows?

Enter the required values into the input fields and press the calculate button. The tool applies the formula NPV = Σ CFₜ ÷ (1 + r)ᵗ, t = 0 … n and returns the result with a short explanation of each step, so you can check the working yourself.

Q: What discount rate should I use?

Use the opportunity cost of capital — the return you could earn on an equally risky investment, often approximated by the company's weighted average cost of capital or a market benchmark plus a risk premium. A higher discount rate lowers NPV because future cash flows are worth less today. Testing a range of rates (sensitivity analysis) is standard practice before deciding.

Q: Why is my NPV negative when total inflows exceed the investment?

Because NPV discounts future cash flows to present value, and money received later is worth less than money now. If the inflows are far in the future or the discount rate is high, their present value can fall below the initial investment even when the undiscounted sum is larger. NPV answers 'is this project worth more than investing the money elsewhere', not 'do inflows exceed outflows'.

Q: What is the profitability index?

The profitability index is the ratio of the present value of future cash flows to the initial investment: PI = PV of inflows ÷ initial outlay. A PI above 1 means the project creates value, and it ranks projects by value created per dollar invested — useful when capital is limited and projects compete. NPV gives the absolute value, PI gives the efficiency.

Q: What cash-flow pattern makes NPV turn negative?

Late or shrinking inflows. Take −$1,000 now plus $300/$400/$500 over three years at 10%: the discounted inflows are $272.73 + $330.58 + $375.66 = $978.97, giving NPV ≈ −$21.03 even though the $1,200 total exceeds the investment. Money arriving later is worth less, which is exactly the mistake NPV prevents.

Q: How do I choose the discount rate?

Use your cost of capital or minimum required return — often the company's weighted average cost of capital (WACC), commonly 8–12% for established businesses. A startup might use 20%+ to reflect risk. Raising the rate penalizes distant cash flows more, so riskier projects need earlier, larger inflows to stay positive.

Q: What does the profitability index add beyond NPV?

It scales the result: PI = present value of inflows ÷ initial investment. A project with NPV of $176 on a $10,000 investment has PI ≈ 1.018 — it returns about 1.8% above the hurdle in present-value terms. When capital is rationed, ranking projects by PI picks the most value per dollar invested.

Q: Can NPV handle uneven or missing years?

Yes — each cash flow is discounted by its own year's factor (1+r)ᵗ, so years can be skipped or irregular. A $5,000 inflow in year 5 at 10% contributes 5000/1.6105 ≈ $3,104.61 regardless of what happens in years 1–4. Just list each flow against its correct year, starting with year 0 for the initial outlay.

Inside the Npv Calculator Online

Every result on this page comes from a real formula — NPV = Σ CFₜ ÷ (1 + r)ᵗ, t = 0 … n — computed live in your browser the moment you press the button.

The reference table below covers the most common npv calculator cases at a glance, the methodology section breaks the calculation into verifiable steps, and the FAQ tackles the edge cases.

Quick reference

Cash flows @10%	NPV
−1000, 300, 400, 500	−$21.04
−1000, 400, 400, 400	−$5.26
−1000, 500, 500, 500	+$243.43
−5000, 2000, 2000, 2000, 2000	+$1,339.73

info Npv Calculator Online

Free math calculator — enter your numbers and get an instant, accurate result.

info Private by design

Everything runs locally in your browser. No uploads, no accounts, no tracking.

info Works everywhere

Fully responsive and mobile-friendly — calculate on any device, any time.

info Educational

Includes the formula and step-by-step explanation so you understand the math, not just the answer.

Interpretation guide

NPV	Decision rule
> 0	Accept — creates value above the hurdle rate
= 0	Break-even — earns exactly the discount rate
< 0	Reject — destroys value at this rate

lightbulb Worked example: $10,000 project at 8%

A business invests $10,000 now and receives $3,000, $4,000, and $5,000 at the end of years 1, 2, and 3. The discount rate (cost of capital) is 8%. Discount each inflow: Year 1: 3000 / 1.08 = 2,777.78. Year 2: 4000 / 1.08² = 4000 / 1.1664 = 3,429.36. Year 3: 5000 / 1.08³ = 5000 / 1.2597 = 3,969.16. Present value of inflows = 2,777.78 + 3,429.36 + 3,969.16 = 10,176.30. NPV = 10,176.30 − 10,000 = 176.30.

Result: NPV ≈ +$176.30; profitability index ≈ 10,176.30 / 10,000 = 1.018.

What this means: A positive NPV means the project earns about $176 more than the 8% hurdle requires — accept it. Note the total inflows ($12,000) look comfortable, but discounting shaves $1,824 off their apparent value; timing is doing real work here, which is exactly what NPV exposes.

Formula & methodology

Formula: NPV = Σ CFₜ ÷ (1 + r)ᵗ, t = 0 … n

How NPV is computed

Net present value discounts every future cash flow back to today's money and adds them up:

NPV = Σ CFₜ / (1 + r)ᵗ for t = 0 … n

List cash flows by year, starting with year 0 — the initial investment as a negative number.
Divide each year's flow by (1 + r)ᵗ, where r is the discount rate (e.g. 0.10 for 10%).
Sum the discounted flows. A positive NPV means the project beats the hurdle rate.

Profitability index

The profitability index = present value of inflows ÷ initial investment. A project investing $10,000 for inflows worth $10,176 today has PI ≈ 1.018 — it creates about 1.8% more value than the required return, which is useful for ranking projects when capital is limited.

Authoritative source: Wolfram MathWorld

Frequently asked questions

What is net present value?

The Npv Calculator Online is free, private, and accurate: it runs entirely in your browser (no uploads, no accounts), applies the standard calculation, and explains each step so you can verify the result. Calculates npv using NPV = Σ CFₜ ÷ (1 + r)ᵗ, t = 0 … n, in real time in your browser. There is no limit on usage, and it works on any device.

How do I enter the cash flows?

Enter the required values into the input fields and press the calculate button. The tool applies the formula NPV = Σ CFₜ ÷ (1 + r)ᵗ, t = 0 … n and returns the result with a short explanation of each step, so you can check the working yourself.

What discount rate should I use?

Use the opportunity cost of capital — the return you could earn on an equally risky investment, often approximated by the company's weighted average cost of capital or a market benchmark plus a risk premium. A higher discount rate lowers NPV because future cash flows are worth less today. Testing a range of rates (sensitivity analysis) is standard practice before deciding.

Why is my NPV negative when total inflows exceed the investment?

Because NPV discounts future cash flows to present value, and money received later is worth less than money now. If the inflows are far in the future or the discount rate is high, their present value can fall below the initial investment even when the undiscounted sum is larger. NPV answers 'is this project worth more than investing the money elsewhere', not 'do inflows exceed outflows'.

What is the profitability index?

The profitability index is the ratio of the present value of future cash flows to the initial investment: PI = PV of inflows ÷ initial outlay. A PI above 1 means the project creates value, and it ranks projects by value created per dollar invested — useful when capital is limited and projects compete. NPV gives the absolute value, PI gives the efficiency.

What cash-flow pattern makes NPV turn negative?

Late or shrinking inflows. Take −$1,000 now plus $300/$400/$500 over three years at 10%: the discounted inflows are $272.73 + $330.58 + $375.66 = $978.97, giving NPV ≈ −$21.03 even though the $1,200 total exceeds the investment. Money arriving later is worth less, which is exactly the mistake NPV prevents.

How do I choose the discount rate?

Use your cost of capital or minimum required return — often the company's weighted average cost of capital (WACC), commonly 8–12% for established businesses. A startup might use 20%+ to reflect risk. Raising the rate penalizes distant cash flows more, so riskier projects need earlier, larger inflows to stay positive.

What does the profitability index add beyond NPV?

It scales the result: PI = present value of inflows ÷ initial investment. A project with NPV of $176 on a $10,000 investment has PI ≈ 1.018 — it returns about 1.8% above the hurdle in present-value terms. When capital is rationed, ranking projects by PI picks the most value per dollar invested.

Can NPV handle uneven or missing years?

Yes — each cash flow is discounted by its own year's factor (1+r)ᵗ, so years can be skipped or irregular. A $5,000 inflow in year 5 at 10% contributes 5000/1.6105 ≈ $3,104.61 regardless of what happens in years 1–4. Just list each flow against its correct year, starting with year 0 for the initial outlay.

Explore the full math toolkit

Every CalcaTools math calculator — algebra, geometry, trigonometry, statistics, sequences, and unit conversions — with step-by-step workings on every result.