NPV Calculator
Net present value discounts future cash flows back to today and subtracts the initial investment. A positive NPV suggests the project creates value at the chosen discount rate.
Enter the investment, discount rate and cash flows.
What NPV measures
A dollar received in the future is worth less than a dollar today, because it could be invested in the meantime. Net present value discounts each future cash flow by the required return and adds them up, then subtracts the initial cost.
A positive NPV means the project is expected to earn more than the discount rate. A negative NPV means it falls short. Among competing projects, the higher NPV is generally preferred, subject to risk and capital constraints.
The formula
C₀ = initial investment · C₁–C₄ = cash flows · r = discount rate
The discount rate is often the company’s cost of capital or an investor’s required return. A higher rate reduces the present value of distant cash flows.
A worked example
Investing 10,000 for cash flows of 3,000, 4,000, 5,000 and 3,000 at an 8% discount rate gives a present value of about 12,381. The NPV is 2,381, and the profitability index is 1.24.
The undiscounted net cash is 5,000. The difference between that and the NPV is the cost of waiting for the money.
Limits of a four-year model
Many projects have cash flows beyond four years or a terminal value. This calculator covers the first four years, which is enough for a quick comparison. For a full valuation, extend the model and include salvage value or continuing cash flows.
Choosing the discount rate
For a company, the weighted average cost of capital is a common starting point. For an individual, the rate might reflect the return available on a similar-risk investment. A higher rate makes the project look less attractive; a lower rate makes it look better.
NPV versus IRR
The internal rate of return is the discount rate that makes NPV zero. IRR is intuitive as a percentage, but it can be misleading when cash flows change sign or when projects differ in size. NPV is usually the more reliable decision rule.
Risk and sensitivity
Forecasts are uncertain. Test the NPV with lower cash flows or a higher discount rate to see how robust the decision is. A project that is only marginally positive may not be worth the risk.
Practical use
NPV is used for capital budgeting, equipment purchases, property investments and business cases. It forces the analysis to consider the timing of cash, not just the total. Pair it with qualitative factors such as strategic value and risk.
How to check the result
Recompute one discount factor. At 8%, the year-three factor is 1 ÷ 1.08³ = 0.7938, so $5,000 becomes $3,969. If your figure differs, the exponent or the rate is wrong.
Confirm the identity: present value of inflows minus the initial investment equals NPV. The profitability index is that present value divided by the investment, so 12,381 ÷ 10,000 = 1.24 matches an NPV of 2,381.
Check the sign of the first cash flow. Entering the investment as a positive flow adds it instead of subtracting it, and the NPV rises by twice the outlay.
Common mistakes to avoid
Mixing nominal cash flows with a real discount rate is the most damaging error, because the result can flip from positive to negative. Match the two: nominal flows with a nominal rate, or real flows with a real rate.
Discounting the first cash flow at year zero, or counting the initial outlay as year one, shifts every term by a year. Ignoring a terminal value understates long-lived projects, while ignoring working capital and tax overstates them.
Ranking projects by internal rate of return alone favours small, fast-payback schemes over larger ones that add more value. Comparing NPVs without checking the capital required does the reverse.
Sensitivity testing is the practical answer: rerun the numbers with a lower cash flow and a higher rate, then see whether the decision still survives.
What changes the number most
The discount rate hits distant flows hardest. At 8%, the year-four flow of $3,000 is worth $2,205; at 12% it falls to $1,907, a drop of about 13.5%. Early flows barely move.
The size and timing of the largest cash flow dominate the total. Moving a $5,000 inflow from year three to year two adds about $318 at 8%.
Late cash flows carry most of the uncertainty. A project whose value depends on a terminal year is far more sensitive to assumptions than one that recovers its cost early.
Frequently asked questions
What does a positive NPV mean?
The project is expected to return more than the discount rate used, so it adds value in current money. A negative figure means it falls short of that required return. Compare the size of the NPV across projects rather than only the sign.
What discount rate should I use?
Use the cost of capital for a business project, or the return available on a comparable-risk investment for a personal one. The rate should reflect the risk of the cash flows, and a higher rate makes distant flows worth less.
How is NPV different from profit?
NPV accounts for when cash arrives by discounting later flows, and it uses cash rather than accounting figures. Profit follows accrual rules that may recognise revenue before the cash appears. A profitable project can still have a negative NPV if the cash arrives too late.
Can I use this for more than four years?
Not directly, because the model covers four annual cash flows. For longer projects, discount each additional year in a spreadsheet or add a terminal value. The principle is identical; only the number of terms changes.
What is the profitability index?
The present value of the inflows divided by the initial investment. A value above 1.0 means the project creates value at the chosen rate, and 1.24 means $1.24 of present value per dollar invested. It helps compare projects of different sizes.
Sources & methodology
- Corporate finance principles — discounted cash flow and net present value.
- Calculation method: annual discounting of four cash flows minus the initial investment.
Educational information only — not financial, tax or investment advice. Confirm important decisions with a qualified professional.