NPV Calculator with Discounted Payback Schedule

NPV Calculator detailed calculation results
Year	Net cash flow	Discount factor	Present value	Cumulative NPV
1	$25,000.00	0.91	$22,727.27	-$77,272.73
2	$25,750.00	0.83	$21,280.99	-$55,991.74
3	$26,522.50	0.75	$19,926.75	-$36,064.99
4	$27,318.18	0.68	$18,658.68	-$17,406.31
5	$28,137.72	0.62	$17,471.31	$65.00

At a glance

NPV Calculator: quick answer

Calculate net present value, profitability index, and discounted payback from an investment and growing annual cash flows.

Key inputs

Initial investment, First-year net cash flow, Forecast years, and Annual discount rate.

What you get

Net present value, Present value of net inflows, Profitability index, and Discounted payback.

Best way to use it

Build a realistic base case, then change one assumption at a time and compare the chart and table, not only the first result.

What this calculator does

Net present value compares an investment made today with the value today of the net cash it may produce later. It is one of the clearest ways to account for both cash-flow timing and a required return.

A positive NPV means the modeled future net cash flows exceed the initial investment after discounting. A negative NPV means they do not meet the selected return threshold under the assumptions entered.

This streamlined model supports a growing annual cash-flow series and explicit final-year values. More irregular projects should be evaluated in a full cash-flow model with every material outflow entered in the correct period.

This page is built for users who need a defensible planning answer, not just quick arithmetic. It translates "Initial investment", "First-year net cash flow", and "Forecast years" into "Net present value", "Present value of net inflows", and "Profitability index" so the trade-off is visible in one place instead of being hidden behind a single number. It is also useful for comparing closely related searches such as "net present value calculator calculator" and "discounted payback calculator calculator", as long as the assumptions match the product or decision you are actually evaluating.

How to use the npv calculator

Enter the initial cash investment, first-year net cash flow, forecast length, discount rate, and annual cash-flow growth.
Add a terminal or resale value only when it is economically justified. Add any final-year closure or disposal outflow separately.
Compare conservative, base, and optimistic cases. Change the discount rate and growth assumption independently so sensitivity remains understandable.
Start with "Initial investment", "First-year net cash flow", and "Forecast years", then check whether the first output cards already answer your question. After that, add advanced assumptions such as "Terminal or resale value" and "Final-year additional outflow" only when they are real enough to change the decision.

Formula and methodology

The initial investment is recorded as a negative cash flow at time zero. Annual net cash flow grows at the entered rate and is discounted to present value.

Terminal value and final-year additional outflow are included in the last year's net cash flow before discounting.

Profitability index equals present value of future net inflows divided by the initial investment. Discounted payback is interpolated within the year when cumulative discounted value crosses zero.

The model maps "Initial investment", "First-year net cash flow", and "Forecast years" into "Net present value", "Present value of net inflows", and "Profitability index" using the formulas shown on the page. Keeping those relationships visible makes it easier to separate the core economics from the optional adjustments and to understand which assumption is actually moving the answer.

Net present value formula

NPV = -Initial investment + sum(Cash flow at t / (1 + r)^t)

Profitability index = Present value of future net inflows / Initial investment

The discount rate r should reflect the opportunity cost and risk relevant to the decision.

Worked example and practical context

An investment of 100,000 that produces five growing annual cash flows may have a positive accounting profit but a negative NPV if those receipts arrive too slowly for a 10% required return.

A terminal value can materially change the answer. That is a reason to document and stress test it, not a reason to use an optimistic value to force a positive result.

How to interpret the results

Positive NPV indicates value above the selected hurdle rate within this model. It does not remove execution, financing, liquidity, or forecast risk.

Profitability index is useful when capital is constrained, while discounted payback helps expose how long capital remains economically unrecovered.

Read "Net present value" first, then use the other summary cards, the chart, and the detailed table to judge cash flow today and value creation over time. In most finance decisions, the best option is the one that stays strong across the full picture, not just the one with the most attractive first number.

Common mistakes to avoid

Using revenue instead of net cash flow.
Selecting a discount rate that does not reflect risk or funding cost.
Using an unsupported terminal value to dominate the result.
Mixing nominal cash flows with a real discount rate or vice versa.

Key terms

NPV: Present value of future net cash flows minus the initial investment.
Profitability index: Present value of future net inflows divided by the initial investment.
Discounted payback: The modeled time needed for cumulative discounted cash flows to recover the initial investment.

Frequently asked questions

Practical answers about assumptions, results, and responsible use.

What does a positive NPV mean?

It means the modeled future net cash flows exceed the initial investment after applying the selected required return.

Why can a profitable project have negative NPV?

Accounting profit may ignore timing and opportunity cost. NPV can be negative when cash arrives too late or is too small for the selected discount rate.

What if discounted payback is zero?

On this page, zero means the investment does not achieve discounted payback within the forecast period.

How is this different from the DCF calculator?

This page evaluates NPV against an explicit initial investment and payback threshold. The DCF page focuses on estimating enterprise value including a perpetuity-style terminal value.

Which inputs change "Net present value" the most?

Start with "Initial investment", "First-year net cash flow", and "Forecast years". Those assumptions usually drive "Net present value" far more than any optional adjustment. Once the base case is right, use advanced inputs only to reflect real fees, taxes, or timing differences.

What does "Net present value" tell me in practical terms?

"Net present value" is the fastest read on the outcome, but it should not be treated as the whole decision by itself. Use it as the headline number, then read the chart, table, and other summary cards to understand what is happening underneath.

Why should I look at "Present value of net inflows" as well as "Net present value"?

Because "Net present value", "Present value of net inflows", and "Profitability index" answer different parts of the same decision. A scenario can look good on the first number and still be weak once timing, total cost, or long-run value is included.

When should I use "Terminal or resale value"?

Use advanced fields such as "Terminal or resale value" and "Final-year additional outflow" when they are real and material in your case. If you are still exploring, leave them at zero first so the base case stays easy to interpret.

What happens if the advanced options stay at zero?

Then the calculator runs a simpler base case using the main inputs only. That is often the best place to start, because it makes it easier to see what changes once optional costs, fees, taxes, or adjustments are layered in.

Does the chart add anything beyond the summary cards?

Yes. The chart shows how the result develops over time, which is often the real decision point. It is especially useful when two scenarios have a similar headline result but very different timing or cost patterns.

What is the detailed table useful for?

Use the table when you need the period-by-period breakdown behind the summary. That is usually where users spot front-loaded interest, a slow payoff path, a contribution gap, or the exact point where one scenario becomes better than another.

Should I compare more than one npv case?

Yes. A base case and one stressed case usually give a much better planning view than a single run. Change one major assumption at a time so you can see what is actually responsible for the difference.

NPV Calculator

NPV Calculator

Cumulative discounted value

Detailed result table

Calculation notes

Scenario comparison