How to use Net Present Value Calculator
- 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.
- 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.
- 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.
- Select Calculate result. Review each Present value and the NPV total, which sums unrounded calculated values rather than the displayed rounded rows.
- 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.
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.