NPV Calculator – Net Present Value

How to use this Net Present Value calculator

What this calculator does

This calculator estimates the net present value (NPV) of a project or investment with one upfront cost and up to nine annual net cash flows. It converts each future cash flow into today's dollars using your annual discount rate, adds those present values, and subtracts the initial cost. NPV is a discounted-cash-flow comparison, not a guarantee of profitability, market value, financing availability, or realized return. The calculation assumes each listed annual cash flow occurs at the end of its year and that one discount rate applies across the entire horizon. For a broader introduction to this method, OpenStax explains how discounted cash-flow models support capital investment decisions.

When to use it

Use NPV when comparing a project's expected future receipts with an upfront investment, screening capital-budget proposals, evaluating equipment or software purchases that produce multi-year savings, or comparing alternatives whose cash flows arrive at different times. It is especially useful when the timing of money matters: receiving $5,000 one year from now is not treated as economically identical to receiving the same $5,000 several years later.

How to calculate

1. The calculator opens with a complete demonstration: a 5% discount rate, $10,000 of Initial costs, and five annual cash flows. Its example Excel workbook is available immediately.
2. Replace the Discount rate with the annual rate appropriate to your analysis. Then enter the positive Initial costs paid at time 0.
3. Enter Year 1 through Year 5 cash flows. Use positive dollar values for net inflows and negative values for net outflows. Leave unused trailing years blank. Select Show more annual cash flows to reveal Years 6 – 9.
4. Read Net present value first, then review Expected cash flows, Initial costs, Analysis horizon, and the discounted cash-flow schedule. Use Download Excel to export the current validated assumptions and results.
5. Reset clears the demonstration values, extra-year selection, results, schedule, and workbook state. Download Excel is disabled after a cleared reset until you enter a complete valid state again.

Input guide

Discount rate is required and is entered as an annual percentage greater than -100%; for example, enter 5 for 5%. A higher positive rate reduces the present value of later cash flows. Do not type a decimal fraction such as 0.05 if you mean 5%, and do not use scientific notation such as 1e2. Initial costs is required, uses U.S. dollars, and must be zero or positive; 10000 means an upfront $10,000 investment. Enter the cost as positive because the model subtracts it at time 0.

Year 1 through Year 9 are annual net cash flows in U.S. dollars. At least Year 1 must be present, and cash flows must be contiguous through the last used year – do not leave a blank year between two entered years. Positive values represent net inflows; negative values represent additional net outflows. For example, a Year 2 value of -1000 represents a $1,000 outflow at the end of Year 2. Show more annual cash flows is optional and reveals Years 6 – 9 without changing the underlying calculation for any filled values. A common mistake is mixing nominal cash flows that include inflation with a real discount rate that excludes inflation; the cash-flow assumptions and discount rate should be conceptually consistent.

Output guide

Net present value is the present value of all entered future cash flows minus Initial costs. A positive value means the discounted future cash flows exceed the upfront cost under the selected assumptions; zero means they are exactly equal; a negative value means they fall short. Expected cash flows is the combined present value of Years 1 – 9 before subtracting Initial costs. Initial costs repeats the time-0 amount used in the calculation. Analysis horizon is the last contiguous year with a cash-flow entry. The summary pills repeat the current Discount rate, Horizon, Initial costs, and NPV from the same model.

The Discounted cash-flow schedule shows Period, the original Cash flow, the Discount factor, and each flow's Present value. Period 0 uses a discount factor of 1.000000 and presents the initial cost as a negative amount. Later discount factors shrink as time increases when the discount rate is positive. These rows are exact consequences of the entered assumptions, not separate recommendations.

Worked example

The startup example uses a 5% discount rate, $10,000 of Initial costs, and annual cash flows of $5,000, -$1,000, $3,000, $3,000, and $2,000. The calculator discounts each future flow by (1 + 0.05)^year. Their combined present value is $10,481.55. Subtracting the $10,000 initial cost gives an NPV of $481.55. Because this result is positive, the discounted cash flows exceed the initial cost by $481.55 under these assumptions.