About the Net Present Value Calculator
Net present value is the foundation of capital budgeting. It answers a simple but powerful question: if you invest money today and receive cash back over several years, does the total value of those future receipts — adjusted for the time value of money — exceed what you put in? A positive NPV means yes; a negative NPV means the investment destroys value under your assumptions.
NPV Formula
PV of Cash Flow_t = Cash Flow_t ÷ (1 + Discount Rate)^t
PV of Cash Flows = Σ PV of Each Year's Cash Flow
NPV = PV of Cash Flows − Initial Investment
Each future cash flow is discounted by the factor (1 + r)^t, where r is the discount rate and t is the year. A $10,000 cash flow in year 5 at a 10% discount rate is worth $10,000 ÷ 1.10^5 = $6,209 today.
Choosing a Discount Rate
- WACC — Weighted average cost of capital; standard for corporate capital budgeting
- Hurdle rate — Minimum acceptable return set by management (e.g., 12–15%)
- Risk-free rate + premium — Treasury yield plus a risk adjustment for the investment type
- Personal required return — For individual investors, what you expect to earn elsewhere at similar risk
NPV vs. IRR vs. ROI
NPV gives an absolute dollar value — how much value is created. IRR (Internal Rate of Return) finds the break-even discount rate — the rate at which NPV = 0. ROI is a simple percentage return without time-value adjustment. For capital budgeting decisions, NPV is preferred because it directly measures dollar value creation and handles different project sizes correctly.
NPV Decision Rule
Accept projects with NPV > 0 (value creating). Reject projects with NPV < 0 (value destroying). When comparing mutually exclusive projects, choose the one with the higher NPV. A negative NPV does not necessarily mean the project is a bad idea — strategic value, optionality, or risk reduction may justify proceeding despite a negative NPV under base-case assumptions.
NPV projections are only as reliable as the cash flow estimates and discount rate inputs. Small assumption changes can flip the sign. Use this calculator as one input into a broader investment analysis. Not financial advice.
Frequently Asked Questions
What is net present value (NPV)?
Net present value is the difference between the present value of all future cash flows from an investment and the initial cost of that investment. It answers the question: after accounting for the time value of money, does this investment generate more value than it costs? A positive NPV means the investment is expected to create value; a negative NPV means it would destroy value at the given discount rate.
How do you calculate NPV?
NPV = Σ [Cash Flow_t ÷ (1 + Discount Rate)^t] − Initial Investment. Each future cash flow is divided by (1 + r)^t where t is the year number, then all discounted values are summed. That total minus the upfront investment is the NPV. For example: $10,000 investment, 10% discount rate, $4,000/year for 3 years → PV Year 1 = $4,000 ÷ 1.10 = $3,636. PV Year 2 = $4,000 ÷ 1.21 = $3,306. PV Year 3 = $4,000 ÷ 1.331 = $3,005. Total PV = $9,947. NPV = $9,947 − $10,000 = −$53 (slightly negative).
What discount rate should I use for NPV?
The discount rate should reflect the opportunity cost of capital — what you could earn on an alternative investment with similar risk. Common choices include: your company's weighted average cost of capital (WACC) for business projects, a target hurdle rate (e.g., 10–15%), the risk-free rate plus a risk premium, or your personal required rate of return for investment decisions. A higher discount rate makes future cash flows worth less today, resulting in a lower NPV.
What does a negative NPV mean?
A negative NPV means the project's future cash flows, when discounted to present value, are worth less than the initial investment. Under the standard decision rule, a negative NPV project should be rejected because it destroys value at the chosen discount rate. However, NPV calculations depend heavily on assumptions — different discount rates or cash flow projections can flip the sign. A slightly negative NPV may still be worth pursuing for strategic reasons not captured in the model.
Is NPV better than ROI or IRR?
NPV, ROI, and IRR each measure different things. NPV tells you the absolute dollar value created or destroyed. ROI measures simple percentage return without time-value adjustment. IRR (Internal Rate of Return) finds the discount rate that makes NPV equal to zero — useful for ranking projects but can be misleading when cash flows change signs multiple times. NPV is generally considered the most reliable metric for capital budgeting because it directly measures value creation in dollars.
Can I enter negative cash flows in individual years?
Yes. Negative cash flows represent additional costs or outflows in a given year — common in multi-phase projects, real estate developments, or businesses that require reinvestment during the period. Enter them as negative numbers. The calculator discounts both positive and negative cash flows and sums them correctly.
Why is discounting future cash flows important?
A dollar received today is worth more than a dollar received in the future because today's dollar can be invested to earn a return. Inflation also erodes purchasing power over time. Discounting adjusts future cash flows to their equivalent present-day value, allowing apples-to-apples comparison between cash received at different points in time. Without discounting, a $100,000 payment in 10 years would look the same as $100,000 today — but it's worth far less.
