NPV calculator
This NPV calculator estimates whether expected cash flows exceed the initial cost after discounting at your chosen rate. Use it when reviewing a forecast model, capital budget, investment memo, or board pack.
A positive result may support the proposal, while a negative result may indicate that its projected return does not clear the required threshold. The main decision risk is treating uncertain forecasts as facts, so compare the result with a sensitivity table before approving the proposal.
Enter these values:
| Input | What to enter |
|---|---|
| Initial cost | Amount paid at time 0, entered as a positive cost |
| Required return | Annual percentage used for discounting |
| Flow 1 | Net amount expected at the end of year 1 |
| Flow 2 | Net amount expected at the end of year 2 |
| Flow 3 | Net amount expected at the end of year 3 |
| Additional flows | Add one field for each later annual value |
Calculation: Convert the required return from percentage form to decimal form, discount each future value, add those present values, and subtract the initial cost. Keep the rate and timing units consistent: an annual percentage requires annual periods.
Output: The net present value is shown in the same currency as the inputs. The calculation should retain full precision and round the displayed value to two decimal places.
Before relying on that output, understand what the result represents and how it differs from the output of a present value calculator.
What does the calculator result mean?
The result measures the value created or lost after adjusting future cash flows for timing and the required return. Net present value, commonly shortened to NPV, is not accounting profit.
It uses cash received and paid, including the initial outlay, rather than revenue or earnings recorded under accounting rules.
Interpret the NPV value using this decision rule:
- Positive NPV: The present value of expected inflows exceeds the initial cost at the selected discount rate. The proposal may create value under the stated assumptions.
- Zero NPV: The present value of expected inflows equals the initial cost. The proposal earns the required return in the model.
- Negative NPV: The present value of expected inflows falls short of the cost. The proposal may reduce value relative to the required return.
The size of the result also matters. A small positive value offers less room for forecast error, a medium value provides more modeled headroom, and a large value provides the most headroom.
These ranges must be defined relative to the initial cost, forecasting uncertainty, and available alternatives. NPV should therefore be compared with the initial cost rather than read as an isolated number.
The discount rate expresses the return required for time, risk, and alternative uses of capital. Increasing it reduces the present value of later cash flows because those amounts are discounted more heavily.
After interpreting the output, review the net present value formula itself.
What is the net present value formula?
The business question is whether the present value of forecast cash flows exceeds the cash paid at the start. The net present value formula answers that question by adding the present value of every future cash flow and subtracting the initial outlay.
NPV=-C_0+\sum_{t=1}^{n}\frac{C_t}{(1+r)^t}Where:
- \(NPV\) = net present value, measured in currency.
- \(C_0\) = initial investment at time 0, measured in currency.
- \(C_t\) = net cash flow received or paid in period \(t\), measured in currency.
- \(r\) = discount rate per period in decimal form; 10% in percentage form is entered as 0.10 in decimal form.
- \(t\) = time period number.
- \(n\) = total number of future periods.
The formula uses a sign convention: inflows are positive, and outflows are negative. This calculator presents the initial investment as a positive cost and subtracts it automatically.
Later costs should be entered as negative flows so their present value reduces NPV.
Timing is assumed to be end-of-period. A year-one amount is discounted once, while a year-three amount is discounted three times.
If flows arrive monthly, use a monthly percentage and monthly periods; mixing monthly values with an annual percentage distorts the net present calculation.
A present value calculator answers a related but narrower question. It discounts one future amount, while an NPV calculation combines multiple discounted amounts and the initial investment.
For example, a present value calculator can value a single payment due in three years, but it does not automatically account for a time-zero cost and a series of later inflows.
IRR reverses the question by finding the rate that makes NPV equal zero, although unusual flow patterns can produce multiple IRR results. The methodology explains how this page applies the formula.
Methodology, assumptions, and limitations
This page applies the standard discounted cash flow method to convert each forecast value into present-value terms. It divides every future amount by one plus the discount rate raised to the relevant time period, totals those amounts, and deducts the initial investment.
A present value calculator uses the same discounting principle for one future amount rather than a complete series.
Data sources: All cash flows, timing estimates, and the required return come from the user. No market benchmark, inflation assumption, tax treatment, or company forecast is supplied automatically.
For general educational tools, see the Investor.gov financial tools and its compound interest calculator.
Updated: August 11, 2026. The net present value formula itself is not date-sensitive, but the appropriate discount rate and forecast values depend on the decision date, financing environment, and project risk.
The calculator assumes a constant percentage and end-of-period cash flows. It does not independently model inflation, taxes, depreciation, working capital, financing structure, terminal value, or uneven dates.
Include relevant effects directly in the flows or use a more detailed model. Its output is an estimate, not personalized investment, tax, legal, or accounting advice.
Forecast quality limits calculation accuracy. A precise NPV value can still mislead when sales, costs, timing, or residual value are poorly supported.
Test low, central, and high scenarios using documented assumptions. The complete worked example below shows how those inputs produce a result.
Worked NPV example
Example: A business is reviewing a capital-budget spreadsheet for a three-year equipment purchase. Assume a $100,000 initial investment paid at time 0, a 10% annual discount rate in percentage form, equivalent to 0.10 in decimal form, and end-of-year net cash flows of $45,000, $45,000, and $40,000.
All amounts are in US dollars, inflows are positive, and the initial cost is subtracted.
The present value calculations are:
PV_1=\frac{\$45{,}000}{(1.10)^1}=\$40{,}909.09Where \(PV_1\) is the present value, in US dollars, of the $45,000 net cash flow received at the end of year 1.
PV_2=\frac{\$45{,}000}{(1.10)^2}=\$37{,}190.08Where \(PV_2\) is the present value, in US dollars, of the $45,000 net cash flow received at the end of year 2.
PV_3=\frac{\$40{,}000}{(1.10)^3}=\$30{,}052.59Where \(PV_3\) is the present value, in US dollars, of the $40,000 net cash flow received at the end of year 3.
The total present value of the future cash flows is $108,151.76. Subtracting the $100,000 initial investment produces:
NPV=\$108{,}151.76-\$100{,}000=\$8{,}151.76Where \(NPV\) is the net present value in US dollars after subtracting the time-zero initial investment.
Result: The NPV is positive $8,151.76.
Interpretation: The positive NPV may indicate that the proposal clears the 10% annual hurdle under these assumptions. The comparison basis is the $100,000 initial cost and the present value of the forecast cash flows.
The result does not promise that the business will realize that value; it depends on the stated cash flows arriving on schedule. Entering each amount separately in a present value calculator would produce the same discounted values, but the initial cost would still need to be deducted.
Decision rule: On NPV alone, the proposal clears the modeled hurdle because NPV is greater than zero. The formula does not determine whether its forecast risk, liquidity requirements, or strategic constraints are acceptable.
For a contrasting case, assume the $40,000 year-three value is delayed until year four. Its present value becomes $27,320.54, and NPV falls to $5,419.71.
Change this timing assumption and the result moves because the final inflow is discounted for one additional year. The proposal still has a positive net present value, but its modeled headroom declines by $2,732.05.
These results lead to the practical questions below.
Frequently asked questions
The answers below clarify accuracy, assumptions, privacy, and the next checks to make before using an NPV value in a decision.
How accurate is an NPV calculator?
An NPV calculator is mathematically accurate when the inputs, units, signs, and timing are correct. Its decision value is only as reliable as the forecast and discount rate.
Check formulas, use consistent periods, and test low, central, and high cases. A present value calculator is similarly precise for a single future amount, subject to the quality of its inputs.
How should I choose a discount rate?
The discount rate should reflect the required return for the project’s timing and risk. Depending on the context, that value may come from a company hurdle, weighted average cost of capital, or a return required for a comparable project.
Document the comparison basis and do not choose the rate merely to produce a positive result.
Does the calculator store financial information?
This page does not claim storage, encryption, or deletion capabilities that have not been specified. Treat every value entered into an online tool according to the site’s published privacy policy, and avoid entering confidential project details unless its handling practices are clear.
What should I do after calculating net present value?
After calculating net present value, compare NPV across credible alternatives that use the same timing and discount-rate basis. Then test delays, lower inflows, higher costs, and a higher required return.
Review liquidity, strategic constraints, and nonfinancial risks separately because the formula does not decide whether a proposal fits the organization.
Takeaway: Net present value converts forecast cash flows into today’s value, but a proposal clears its hurdle only under the assumptions entered.
Run a low, central, and high sensitivity test next, with particular attention to the discount rate and the largest or latest cash flow.