NPV calculator
Net present value adds up every year's cash flow after bringing it back to today's rupees at your discount rate. A positive NPV means the investment earns more than that rate; a negative one means it earns less.
| Year | Cash flow | Discount factor | Present value |
|---|---|---|---|
| 0 | −₹5,00,000 (5.00 lakh) | 1 | −₹5,00,000 (5.00 lakh) |
| 1 | ₹1,50,000 (1.50 lakh) | 0.8929 | ₹1,33,929 (1.34 lakh) |
| 2 | ₹1,80,000 (1.80 lakh) | 0.7972 | ₹1,43,495 (1.43 lakh) |
| 3 | ₹2,00,000 (2.00 lakh) | 0.7118 | ₹1,42,356 (1.42 lakh) |
| 4 | ₹1,50,000 (1.50 lakh) | 0.6355 | ₹95,328 |
| 5 | ₹1,00,000 (1.00 lakh) | 0.5674 | ₹56,743 |
The formula
NPV = CF₀ + CF₁ ÷ (1 + r) + CF₂ ÷ (1 + r)² + … + CFₙ ÷ (1 + r)ⁿ, where CF₀ is today's amount (usually the negative investment), CFₙ the cash flow at the end of year n and r the discount rate.
Worked example
A bakery buys an oven and fit-out for ₹5,00,000. It expects extra cash of ₹1,50,000, ₹1,80,000, ₹2,00,000, ₹1,50,000, ₹1,00,000 over the next 5 years. At a discount rate of 12%, the NPV is ₹71,850. The investment earns more than 12% a year. At 18% the NPV would be −₹803.
Discount factors
The present value of ₹1 received at the end of each year.
| Year | 8% | 10% | 12% | 15% | 18% |
|---|---|---|---|---|---|
| 1 | 0.9259 | 0.9091 | 0.8929 | 0.8696 | 0.8475 |
| 2 | 0.8573 | 0.8264 | 0.7972 | 0.7561 | 0.7182 |
| 3 | 0.7938 | 0.7513 | 0.7118 | 0.6575 | 0.6086 |
| 4 | 0.735 | 0.683 | 0.6355 | 0.5718 | 0.5158 |
| 5 | 0.6806 | 0.6209 | 0.5674 | 0.4972 | 0.4371 |
| 6 | 0.6302 | 0.5645 | 0.5066 | 0.4323 | 0.3704 |
| 7 | 0.5835 | 0.5132 | 0.4523 | 0.3759 | 0.3139 |
| 8 | 0.5403 | 0.4665 | 0.4039 | 0.3269 | 0.266 |
| 9 | 0.5002 | 0.4241 | 0.3606 | 0.2843 | 0.2255 |
| 10 | 0.4632 | 0.3855 | 0.322 | 0.2472 | 0.1911 |
More business calculators
- Business and accounting calculators
- Break-even calculator
- Gross profit calculator
- EBITDA calculator
- ROI calculator
- IRR calculator
- Payback period calculator
- Working capital calculator
- Current ratio calculator
- Quick ratio calculator
- Debt to equity ratio
- Inventory turnover calculator
- Debtor days calculator
- Depreciation calculator
- Cash flow forecast
- Accounting basics
Questions people ask
What discount rate should I use?
The return you give up by putting money here: the interest rate on the loan that pays for it, or what the money would earn in your next best use. Many owners add a few points for risk. Try two or three rates to see how sensitive the answer is.
Why does Excel's NPV give a different answer?
Excel's NPV function treats the first value as arriving at the end of year 1, so it discounts it too. The usual way is NPV(rate, year 1 to year n) + year 0 amount. Done that way, Excel's own example (8%, −40,000 then 8,000, 9,200, 10,000, 12,000 and 14,500) gives 1,922.06, the same as this calculator.
Should cash flows include depreciation?
No. Use cash actually received and paid. Depreciation is not a cash payment; the cash went out when you bought the asset, in year 0. Do include tax paid, and any resale value of the asset in the last year.
NPV or IRR, which is better?
NPV tells you how many rupees of value a project adds at your rate; IRR gives the rate at which NPV is zero. When choosing between projects of different sizes, NPV is the safer guide.
A tax professional can call you back. Asking is free.
Get helpMore calculators
Results are estimates for information only, not financial or tax advice. Rates, rules and limits change, so check with your bank, employer or a qualified adviser before you decide.