NPV Calculator – Net Present Value
Net Present Value Calculator
Discount a sequence of annual cash flows into today’s dollars, compare them with the upfront cost, and inspect exactly how timing changes project value.
Investment assumptions
Initial cost is entered as a positive amount and treated as a time-zero outflow. Later cash flows may be positive or negative.
Additional annual cash flows (Years 6–9)
Cash flow timing and present value
Nominal cash flow, discounted value, and cumulative NPV by year
| Period | Cash flow | Discount factor | Present value | Cumulative future PV | Cumulative NPV |
|---|
How to use and interpret the NPV calculator
What this calculator estimates
Net present value converts future cash flows into today’s dollars and then subtracts the initial investment. It is designed for project appraisal, equipment purchases, product launches, property improvements, and other decisions with an upfront cost followed by a sequence of cash inflows or outflows. The result is an absolute dollar measure of value creation at the discount rate you specify.
NPV = −Initial cost + Σ [Cash flow in year t ÷ (1 + discount rate)t]
Discount rate
Enter an annual percentage greater than −100%. In business analysis, the rate often represents a required return, a risk-adjusted hurdle rate, or the weighted average cost of capital. A higher rate reduces the present value of later cash flows more aggressively, so NPV normally falls as the discount rate rises. Keep nominal cash flows paired with a nominal rate that includes inflation, or real cash flows paired with a real rate. Mixing those conventions is a common modeling error.
Initial costs
Enter the time-zero investment as a positive dollar amount. The model automatically treats it as an outflow, so there is no need to type a minus sign. Include expenditures that occur immediately and are incremental to the decision, such as purchase price, installation, launch spending, or initial working capital. Exclude sunk costs already incurred. A larger initial cost lowers NPV dollar for dollar.
Annual cash flows
Enter the expected net cash movement for each year. Positive values are inflows; negative values are later outflows such as maintenance, remediation, or additional investment. Use cash flow rather than accounting earnings: noncash depreciation is not itself a cash outflow, while taxes, capital expenditure, and working-capital changes can matter. Years 6–9 are optional and remain available in the additional-cash-flow panel. Zero is valid when no cash movement is expected.
Net present value and expected cash flows
Net present value is the primary output. A positive result means the modeled cash flows exceed the selected required return; zero means the project earns exactly that rate; a negative result means it falls short. Expected cash flows is the present value of future net cash flows before subtracting initial costs, matching the conventional companion result for this calculation.
Supporting metrics
Undiscounted net cash simply adds future cash flows and subtracts the initial cost, ignoring timing. The difference between nominal future cash flows and their present value is shown as the discounting impact. The profitability index divides the present value of future cash flows by initial cost. Values above 1.0 correspond to positive NPV when the initial cost is positive; the metric is not meaningful when initial cost is zero.
How to read the chart and schedule
The bars compare each year’s nominal cash flow with its discounted present value. The line tracks cumulative NPV, beginning with the negative initial cost and then adding each discounted cash flow. In the schedule, the discount factor equals 1 ÷ (1 + rate)year. The final cumulative NPV row must equal the headline result. Later cash flows usually show a wider gap between nominal and present value because they are discounted for more periods.
Comparing projects and avoiding common mistakes
When two projects require similar resources and cannot both be accepted, compare their NPVs using consistent assumptions and the same valuation date. A higher positive NPV indicates more modeled dollar value, but project scale, duration, liquidity, and risk still matter. Do not choose a project solely because its undiscounted cash total is larger: cash received earlier generally contributes more present value. Avoid double-counting financing costs when the discount rate already reflects the cost of capital, and avoid adding accounting depreciation as a cash outflow. Terminal proceeds, shutdown costs, and recovered working capital should be placed in the year when cash is actually expected. Finally, do not round each year’s present value before summing; this calculator keeps full precision internally and rounds only displayed and exported values.
Sensitivity, limitations, and source context
NPV is highly sensitive to forecast quality and the discount rate. Test conservative, base, and upside cash-flow cases, and rerun the model at several rates rather than relying on one point estimate. Consider strategic benefits, liquidity constraints, financing structure, taxes, and real-option value separately when they are material. For rate context, review the Federal Reserve’s selected interest rates and U.S. Treasury market rates. The U.S. Small Business Administration provides broader financial-management guidance, while Investopedia’s NPV overview offers additional educational context. This calculator is an analytical aid, not personalized investment, tax, or legal advice.