Skip to content
FinCalcHub

NPV Calculator

Business

Net present value tells you whether a project earns more than your required return, in today’s money.

In short: The NPV Calculator is a free online tool that lets you judge a project by discounting its future cash flows to today — instantly, with charts, a worked example and the exact formula.

Net present value

₹22,631

Worth it

Total inflows

₹7,20,000

Undiscounted

Initial investment

₹5,00,000

Cumulative discounted cash flow

When the project crosses zero, it has recovered its cost in today’s money.

Year-wise discounted cash flow

Year-wise discounted cash flow
YearCash flowDiscountedCumulative
1₹1,20,000₹1,09,091-₹3,90,909
2₹1,20,000₹99,174-₹2,91,736
3₹1,20,000₹90,158-₹2,01,578
4₹1,20,000₹81,962-₹1,19,616
5₹1,20,000₹74,511-₹45,106
6₹1,20,000₹67,737₹22,631

Each inflow discounted to today, then accumulated.

How the NPV Calculator works

Formula

NPV = Σ [ CFₜ ÷ (1 + r)ᵗ ] − Initial investment
CFₜ
Cash flow in year t
r
Discount rate (required return, as a decimal)
t
Year number, from 1 to project life
Σ
Sum across all project years

Step-by-step calculation

Worked with the default values.

  1. 1

    Initial outlay

    Cash flow at year 0

    = -₹5,00,000

  2. 2

    Present value of inflows

    Σ CashFlow ÷ (1 + r)ᵗ

    = ₹5,22,631

  3. 3

    Net present value

    PV of inflows − Initial investment

    = ₹22,631

How it works

  • Every future cash inflow is discounted back to today using the required rate of return.
  • The discounted inflows are summed and the upfront investment is subtracted.
  • A positive NPV means the project earns more than your hurdle rate and adds value; a negative NPV means it destroys value.

Examples

₹5,00,000 outlay returning ₹1,20,000/year for 6 years at 10%

NPV of about ₹22,600 — marginally worth it.

The same project appraised at a 15% discount rate

NPV turns negative, so a higher hurdle rate makes it unattractive.