Net Present Value (NPV) Calculator
Calculate the net present value (NPV) and profitability index of an investment.
What Is the Net Present Value (NPV) Calculator?
The Net Present Value (NPV) Calculator evaluates an investment by discounting future cash flows back to the present using a required rate of return. Enter initial investment cost, expected cash flows for each period, and the discount rate to determine if the investment creates value (positive NPV) or destroys it (negative NPV).
Formula
How to Use
Enter the initial investment (as a negative cash flow in period 0). Enter expected cash flows for each subsequent period. Enter the discount rate (required return, hurdle rate, or WACC). The calculator returns NPV, IRR (internal rate of return), and profitability index.
Example Calculation
Investment: −$10,000. Cash flows: Year 1: $3,000, Year 2: $4,000, Year 3: $5,000. Discount rate: 10%. NPV = 3000/1.1 + 4000/1.21 + 5000/1.331 − 10000 = 2727 + 3306 + 3757 − 10000 = −$210. Slightly negative → reject at 10% hurdle.
Understanding Net Present Value (NPV)
Net Present Value is the gold standard technique for investment appraisal in corporate finance, capital budgeting, and project evaluation. NPV accounts for the time value of money — a dollar today is worth more than a dollar in the future because it can be invested to earn returns. Discounting future cash flows corrects for this, putting all amounts on a comparable present-day basis.
The decision rule is simple: invest if NPV > 0, reject if NPV < 0, and be indifferent if NPV = 0. A positive NPV means the project earns more than the cost of capital, creating shareholder value. The discount rate (hurdle rate) is therefore critical — it represents the minimum acceptable return, typically the company's WACC.
NPV analysis requires estimating future cash flows, which involves uncertainty. Sensitivity analysis (varying the discount rate and cash flow assumptions) and scenario analysis (modeling best, base, and worst cases) are used alongside NPV to assess investment risk. Monte Carlo simulation can generate probability distributions of NPV outcomes for complex projects.
Frequently Asked Questions
What does a positive NPV mean?
A positive NPV means the investment generates more value than it costs when future cash flows are discounted to present value. It means the investment earns more than the required rate of return — accept the project.
What is the discount rate?
The discount rate is the required minimum return on investment — often the company's Weighted Average Cost of Capital (WACC) or an opportunity cost rate. Higher rates make future cash flows worth less.
What is IRR?
The Internal Rate of Return (IRR) is the discount rate that makes NPV exactly zero — the investment's actual expected return rate. If IRR > required return, the project is profitable.
What is the profitability index?
Profitability Index = (NPV + initial investment) / initial investment. PI > 1 means positive NPV; PI < 1 means negative NPV. Useful for ranking projects when capital is limited.
Is this calculator free?
Yes, completely free with no account required.