Free tools that run in your browser. Use any tool without an account.

Favourites Cart
Sign in
Join free

NPV Calculator

Net Present Value

  • Free
  • Runs in your browser
  • No account needed

This NPV Calculator computes net present value, the present value of each cash flow, the profitability index and IRR instantly in your browser; for example, with r = 8% and cash flows -1000, 400, 400, 400 the NPV is $30.79.

Net present value (NPV)
-$21.04
Present value of future cash flows
$978.96
Profitability index
0.979
IRR
8.9%
Decision at this rate
NPV is negative: the project earns less than the discount rate
Runs in your browser. Your files and values are not sent to us. Report a problem
Advertisement

About the NPV Calculator

You enter a discount rate per period and a list of cash flows that starts with the initial outlay as a negative number. The tool discounts each period and shows the present value of each cash flow, the sum of future present values, the net present value, the profitability index and the internal rate of return. Results update instantly as you type and you can pick USD, GBP, EUR, NGN, AED, SAR or INR. The calculator runs entirely in your browser and does not upload your numbers to a server. That makes it fast and private, and gives you a clear present-value schedule and a shareable link to reopen your inputs.

How to use it

  1. 1Enter the discount rate per period as a percentage.
  2. 2Enter cash flows starting with the initial outlay as a negative number.
  3. 3Pick a currency from the list.
  4. 4Watch results update instantly with per-period PVs, NPV, PI and IRR.
  5. 5Copy results or share the link that reopens your inputs.
Advertisement

Worked example

Inputs: Currency = USD, Discount rate = 8.00%, Cash flows = -1000, 400, 400, 400. Present values: PV1 = 400 / 1.08 = 370.37; PV2 = 400 / 1.08^2 = 342.94; PV3 = 400 / 1.08^3 = 317.48. Present value of future cash flows = 1030.79. NPV = -1000 + 1030.79 = 30.79. Profitability index = 1030.79 / -1000 = -1.03079. IRR ≈ 9.70%. Decision at 8%: Accept because NPV > 0.

The formula

NPV = CF0 + CF1 / (1 + r) + CF2 / (1 + r)^2 + .+ CFn / (1 + r)^n, where CF0 is the initial outlay (negative) at time 0 and r is the discount rate per period

Source: Excel XNPV and NPV documentation - Microsoft SupportOMB Circular A-94 on Discount Rates for Benefit-Cost Analysis - White HouseThe Green Book: Central government guidance on appraisal and evaluation - HM Treasury. Last checked 7 November 2026.

What it is good for

  • Updates results instantly as you type.
  • Runs entirely in your browser; no uploads.
  • Shows PV for each cash flow plus NPV, PI and IRR.
  • This tool uses evenly spaced periods only; it does not support exact-date XNPV.
  • Profitability index follows the tool formula and may reflect sign conventions from your inputs.
Advertisement

Questions people ask

What inputs does this calculator need?

You need a discount rate per period in percent and a list of cash flows starting with the initial outlay as a negative number. Choose a currency for display.

Does this handle dated or irregular cash flows?

No. Use XNPV or a dated cash-flow tool when flows fall on irregular calendar dates. See Microsofts XNPV documentation for the exact-date method.

How does the calculator treat the initial outlay?

Enter the initial outlay as a negative number at time 0. The calculator does not discount the time 0 cash flow.

Why do Excel results sometimes differ from this tool?

Excels NPV function assumes the first value is at period 1. You normally add the initial outlay separately in Excel. For dated flows use Excels XNPV function.

How should I pick the discount rate?

Pick the project cost of capital or required return. For public projects, follow guidance such as OMB Circular A-94 in the US or the HM Treasury Green Book in the UK. Run sensitivity checks.

Are the results exact or estimates?

Results are financial estimates based on the inputs and the selected discount rate. For public-sector appraisals use official guidance such as OMB Circular A-94 or the HM Treasury Green Book for formal analysis.

Help keep every tool free

FreeToolr stays free because people help it grow. Share a tool you like, tell us what to build next, or support us on Ko-fi.

Advertisement
Advertisement