Net Present Value (NPV) calculates the current worth of future cash flows discounted by a required rate of return. NPV = Sum of [Cash Flow_t / (1 + r)^t] − Initial Investment. A positive NPV means the investment creates value above your required return; a negative NPV means it does not. It is the gold standard method for evaluating investments, capital expenditures, and business projects.
👉 Free NPV Calculator — instant, no signup required →
What Is Net Present Value (NPV)?
Net Present Value (NPV) is a financial calculation that measures whether an investment is worth making by comparing the value of money you spend today against the value of money you expect to receive in the future. The core idea is the "time value of money" — a dollar today is worth more than a dollar in the future, because today's dollar can be invested to earn returns.
NPV works by "discounting" each future cash flow back to what it is worth in today's dollars, using a discount rate that represents your required return or opportunity cost. You then subtract the initial investment to find whether the project creates or destroys value.
The formula is: NPV = Σ [CF_t / (1 + r)^t] − Initial Investment, where CF_t is the cash flow in period t, r is the discount rate, and t is the time period. If NPV is greater than zero, the investment is expected to generate more value than it costs at your required return. If NPV is less than zero, you would be better off putting that money into your next-best alternative.
NPV is used by businesses to evaluate capital expenditures, acquisitions, product launches, and equipment purchases. It is also used in personal finance to compare decisions like buying vs. leasing, evaluating a graduate degree, or deciding whether to pay off debt early versus investing. Unlike simpler metrics like payback period, NPV accounts for both the time value of money and the total value created over the entire life of the investment.
The NPV Formula
NPV = Σ [CF_t / (1 + r)^t] - I₀
Where:
CF_t = Cash flow in period t
r = Discount rate (required rate of return)
t = Time period (year 1, 2, 3...)
I₀ = Initial investment (negative cash flow at time 0)
Decision rule:
- NPV > 0: Accept the investment (creates value above required return)
- NPV = 0: Indifferent (exactly meets required return)
- NPV < 0: Reject the investment (doesn't meet required return)
- When comparing mutually exclusive projects: choose the higher NPV
Worked Example: Business Equipment Purchase
Should a business invest $50,000 in new equipment that generates $15,000 in additional annual cash flows for 5 years, then has a salvage value of $5,000? Required return: 12%.
| Year | Cash Flow | Discount Factor (12%) | Present Value | |------|-----------|----------------------|--------------| | 0 (Investment) | −$50,000 | 1.000 | −$50,000 | | 1 | $15,000 | 1/1.12 = 0.893 | $13,393 | | 2 | $15,000 | 1/1.2544 = 0.797 | $11,958 | | 3 | $15,000 | 1/1.4049 = 0.712 | $10,677 | | 4 | $15,000 | 1/1.5735 = 0.636 | $9,533 | | 5 | $15,000 + $5,000 = $20,000 | 1/1.7623 = 0.567 | $11,348 | | NPV | | | $6,909 |
NPV = +$6,909 → Accept the investment (creates $6,909 in value above the 12% hurdle rate)
Choosing the Discount Rate
The discount rate represents the opportunity cost of capital — what return you could earn on the next best alternative investment:
For businesses:
- WACC (Weighted Average Cost of Capital): blend of cost of debt and equity
- Typical range: 8–15% for established companies; 15–25% for riskier ventures
- Project risk premium: riskier projects use higher discount rates
For personal finance:
- Conservative personal finance decisions: 4–6% (compare to savings account returns)
- Compare to investment alternatives: 7–10% (compare to expected stock market return)
- Credit card debt comparison: 20–25% (the debt's interest rate is the hurdle rate)
NPV vs. IRR
Internal Rate of Return (IRR) is the discount rate that makes NPV = 0. It tells you the actual annual return of an investment.
Using the equipment example above, the IRR is approximately 18.3% (the rate at which NPV = 0). Since IRR (18.3%) > Required Return (12%), this confirms the investment is worthwhile — same conclusion as positive NPV.
When they disagree (mutually exclusive projects): NPV is the more reliable decision criterion when choosing between projects because it measures absolute value created, not just percentage return. A $1 investment with 200% IRR might create less value than a $1,000,000 investment with 15% IRR if capital is sufficient.
Frequently Asked Questions
What is the time value of money and why does it matter for NPV? The time value of money states that $1 today is worth more than $1 in the future because today's dollar can be invested to earn returns. NPV "discounts" future cash flows back to their present value to make them comparable to today's investment. Without discounting, you could compare a $100 investment that returns $110 in 30 years (bad deal) to one returning $110 in 1 year (good deal) — NPV correctly shows the 30-year investment has negative NPV while the 1-year investment has positive NPV.
How do I calculate NPV in Excel or Google Sheets?
Excel: =NPV(rate, value1, value2, ...) + initial_investment where the NPV function discounts future cash flows only (not the initial investment at time 0). Example: =NPV(0.10, B2:B6) + B1 where B1 is the initial investment as a negative number and B2:B6 are years 1–5 cash flows. Google Sheets uses the same syntax. Note: the Excel NPV function assumes end-of-period cash flows — if flows occur at the beginning of periods, use XNPV instead.
Can NPV be used for personal financial decisions? Yes — NPV applies to any decision involving spending money now for future benefits: Should you buy or lease a car? (Compare NPVs of both options.) Is a graduate degree worth it? (Initial tuition cost vs. higher future salary, discounted at your opportunity cost.) Should you prepay your mortgage? (Compare after-tax return on the prepayment vs. investing that money.) Should you buy or rent a home? (Requires projecting purchase, appreciation, rental equivalent, and all associated costs.)
What does a $0 NPV investment mean? An NPV of exactly $0 means the investment earns precisely the required rate of return — no more, no less. For businesses, this means the project earns exactly the cost of capital (WACC). The IRR equals the discount rate. Whether to accept a zero-NPV project depends on strategic factors (market entry, capability building, competitive necessity) that aren't captured in the cash flow model. Most capital budgeting frameworks require NPV > 0 to accept a project, rejecting zero-NPV investments in favor of alternatives.
What are the limitations of NPV analysis? NPV is powerful but has limitations: cash flow estimates are inherently uncertain; the discount rate selection is subjective; NPV ignores optionality (the value of future flexibility); doesn't easily capture qualitative strategic benefits; assumes cash flows can be reinvested at the discount rate (which may not be possible). For major investments, NPV analysis should be combined with scenario analysis (best/base/worst case), sensitivity analysis (which assumptions drive the outcome most), and qualitative strategic assessment.
Related Free Tools on RoughTools
- ROI Calculator — calculate simple return on investment
- CAGR Calculator — compound annual growth rate for investment performance
- Break-Even Calculator — find minimum revenue to recover investment
Calculate NPV Now
The free NPV Calculator at RoughTools calculates NPV for investments with up to 30 periods of irregular cash flows, shows year-by-year present value breakdown, and computes IRR alongside NPV. No account needed, completely free.