Net Present Value Calculator

Discount equal-period cash flows with editable rows, a period breakdown and cumulative-value chart.

On-device No sign-up Free to use

Calculate result controls

Showing an example. Edit to see your own.

?

Use an annual rate for annual cash flows, or a matching rate for another period.

?

The first line occurs now at period 0. Use negative amounts for payments and positive amounts for receipts. The editable row list holds up to 60 periods; use Advanced raw input for up to 1,201 lines. A longer existing raw series is kept and is never truncated.

More options
?

Labels the amounts you enter. It does not convert currencies or fetch rates.

Processed in your browser. Your inputs stay on this device.

Result

Showing an example.

With -$1,000 at time zero and $400 at the end of each of three periods, a 10% per-period discount rate gives NPV of about -$5.26. The initial -$1,000 is included without discounting.

Net present value is -$5.26 at a discount rate of 10% per period, including the period 0 cash flow.

https://usefreetools.net/net-present-value-calculator · 20 November 2026

Was this helpful?

How to use Net Present Value Calculator

  1. Replace the sample Cash flows by period. The first value is time zero and is not discounted. Enter negative payments and positive receipts; add an explicit initial outlay if your scenario has one.
  2. Keep 0 for an interval without a cash flow so later timing stays correct. Raw input needs one nonblank amount per line. Use Advanced raw input for more than the editable list’s 60 periods, up to 1,201 entries.
  3. Enter Discount rate per period to match each interval: annual for yearly flows, monthly for monthly flows. This calculator does not convert an annual rate to a monthly rate for you.
  4. Select Calculate result. Review each Present value and the NPV total, which sums unrounded calculated values rather than the displayed rounded rows.
  5. Download npv-discounting.csv for the full per-period table and, when available, npv-cumulative.svg for the cumulative-value curve. CSV formula protection can prefix negative values with an apostrophe; check how your spreadsheet imports those cells.

Example: Net Present Value Calculator

With -$1,000 at time zero and $400 at the end of each of three periods, a 10% per-period discount rate gives NPV of about -$5.26. The initial -$1,000 is included without discounting.

You add
Currency used for display: USD; Discount rate per period (%): 10; Cash flows, one per line: -1000 400 400 400
You get
Net present value is -$5.26 at a discount rate of 10% per period, including the period 0 cash flow.

Options

Currency label
The selected currency labels entered flows and present values. The per-period discount rate remains a percentage and no exchange rates are applied.

Supported inputs and limits

  • Use 1 to 1,201 equally spaced cash flows and at most 80,000 raw-input characters.
  • Each amount is within ±1,000,000,000,000, with up to 25 digits and 12 decimal places.
  • Grouping commas and a leading $ are accepted in amount lines.
  • Blank raw lines are refused; use 0 for an empty period.
  • Rate must be greater than -100% and at most 1,000% per period.
More details

The first entry is period 0; later entries occur at each period end.

No irregular-date XNPV, internal-rate solver or implicit first outlay is supplied.

The editable list holds 60 periods; longer existing raw input is retained without truncation.

The total uses unrounded present values while displayed rows and CSV use formatted amounts, including scientific notation at extreme scales.

CSV formula protection may add text prefixes; it is not an importable project.

The curve samples cumulative displayed-row values and is omitted beyond its numeric range; a single-entry run has no curve.

The table and CSV remain available.

NPV follows your rate and cash-flow assumptions, without a risk assessment or investment recommendation.

Processing is local without automatic saving.

Where your input is processed

This tool does not upload your inputs. See the limits for anything saved on your device.

Use the same period throughout

Each flow at period t is divided by (1 + rate)^t. The sum includes positive receipts and negative payments, with no implicit initial outlay.

Questions about Net Present Value Calculator

Is the first cash flow discounted?

No. Line one is period zero. The next line is discounted for one period, and so on.

Should I enter an annual discount rate?

Only if each interval is a year. Match the rate to the actual interval between your entered flows.

Does a positive result guarantee a good investment?

No. NPV follows the entered cash flows and discount assumption. It does not assess risk or whether those amounts will occur.

Page updated · Project managed by Tony Hines · Report a problem with Net Present Value Calculator