NPV Calculator
Discount a list of cash flows to net present value at a rate per period, with the sign convention and timing stated.
What the NPV calculator does
It discounts every cash flow in a list back to period 0 and adds them. The first amount you enter is period 0 and is never discounted; each later amount is divided by (1 + r) raised to its period number. A rate of 10 % per period on -1000, 600, 600 therefore gives -1000 + 600 / 1.1 + 600 / 1.21 = 41.32.
The sign convention is printed with every answer: money going out is negative and money coming in is positive, so the investment at period 0 carries the minus sign. The rate is per period and nominal - the page does not annualise it or adjust it for inflation.
Choose end of period (the default) or beginning of period. Beginning-of-period discounts every flow after period 0 one period less, which is the annuity-due convention. The timing you chose is printed with the result.
The page takes up to 1,000 cash flows and refuses a rate of -100 % or below, because at that point the discount factor divides by zero or changes sign and NPV has no meaning.
How to use it
Enter the cash flows in the text box, one amount per period, with the investment first: -1000, then 600, then 600.
Set the discount rate under Discount rate and choose when each flow occurs. Press Run; the result prints the NPV, the rate per period, the timing and the sign rule it applied.
Do not use thousands separators: write 1000, not 1,000, because a comma separates one flow from the next.
Worked example
Input with the defaults (10 % per period, end of period):
-1000
600
600
Output:
NPV: 41.32
Rate: 10 % per period (nominal, not annualised)
Why it runs in your browser
The discounting happens on this page with JavaScript. No figure you type is sent to a server, and nothing is stored after the tab closes.
Net present value discounts every cash flow in a list back to period 0 and adds them. The first amount is the investment and is never discounted; each later amount is divided by (1 + r) raised to its period number.
The sign convention travels with the answer: money out is negative, money in is positive. At 10 % per period, -1000, 600, 600 gives -1000 + 600 / 1.1 + 600 / 1.21 = 41.32.
The rate is per period and nominal. Choose whether each flow lands at the end or the beginning of its period, and the page prints the choice with the number.
What the discount factor does
A flow in period 3 is worth less than the same flow today. Dividing it by (1 + r)^3 is the arithmetic behind that sentence, and it is why the period-0 investment carries no discount at all.
The beginning-of-period option discounts every flow after period 0 one period less. That is the annuity-due convention, used when a payment arrives at the start of each period rather than the end. The page prints which convention it applied, because the same list gives two different answers.
The cap is 1,000 flows. A rate of -100 % or below is refused: the discount factor would divide by zero or change sign, and the formula has no meaning there.
How to use NPV Calculator
Enter the cash flows into the text box, one amount per period, with the investment first and negative.
Set the Discount rate as a percentage per period, and choose When each flow occurs: end or beginning.
Press Run. The result prints the NPV, the rate per period, the timing and the sign rule. Use `1000`, not `1,000`: a comma separates one flow from the next.
What to Expect
Best for
- Comparing two projects' cash flows at the same discount rate
- Checking a spreadsheet's NPV against an independent arithmetic
- Showing why a later payoff is worth less than an earlier one
Not ideal for
- Choosing the discount rate itself, which is your judgement, not the page's
- Cash flows that change sign many times, where NPV alone can mislead
What this tool keeps
- Every flow in the order you entered it, period 0 first
- The rate per period and the timing convention, printed with the answer
What may need cleanup
- A rate you typed as an annual figure, which this page treats as per period
- A flow with a thousands separator, which is read as two flows
Common errors
- Entering the investment as a positive amount
- Writing 1,000 for a single flow
- Using a rate of -100 % or below
Example use cases
- Screening a capital project before a full model
- Checking an NPV taught in a course
- Comparing a lease against a purchase
Sample input
Cash flows -1000, 600, 600 at 10 % per period, end of period.
Sample output
NPV: 41.32, at 10 % per period, end of each period.
Who this is for
- Analysts checking a discounted cash-flow figure
- Students learning why discounting matters
Frequently asked questions
Why is the first cash flow not discounted?
It sits at period 0, so its discount factor is (1 + r)^0 = 1. The page discounts only the flows after it.
What is the difference between the two timing options?
End of period divides the flow in period t by (1 + r)^t. Beginning of period divides it by (1 + r)^(t - 1), so every flow after period 0 is discounted one period less.
Is the rate annual?
No. It is per period, whatever a period means in your list. If your flows are monthly and your rate is annual, convert the rate before you enter it; the page does not annualise anything.
Why does a negative NPV matter?
It means the flows do not repay the discount rate you set. The page reports the arithmetic, not whether the project should proceed.
Build custom tools for your store
Join the SDK program to create useful ecommerce utilities for your store.