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