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.

Your cost of money: the loan rate, or the return you could get elsewhere
YearCash flow (₹)
0
1
2
3
4
5
Year 0 is the start: enter money you spend as a negative (−500000). Money coming back is positive.
Net present value
₹71,850
Total cash in, not discounted₹7,80,000 (7.80 lakh)
Total cash out₹5,00,000 (5.00 lakh)
Verdict at this rateEarns more than the rate
YearCash flowDiscount factorPresent 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.

Year8%10%12%15%18%
10.92590.90910.89290.86960.8475
20.85730.82640.79720.75610.7182
30.79380.75130.71180.65750.6086
40.7350.6830.63550.57180.5158
50.68060.62090.56740.49720.4371
60.63020.56450.50660.43230.3704
70.58350.51320.45230.37590.3139
80.54030.46650.40390.32690.266
90.50020.42410.36060.28430.2255
100.46320.38550.3220.24720.1911
Excel comparison: Microsoft Support, NPV function, example 2, checked 16 November 2026

More business calculators

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.

Need help with tax, GST or your accounts?

A tax professional can call you back. Asking is free.

Get help

More 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.