Net Present Value (NPV) Calculator

What is the Net Present Value (NPV) Calculator?

Net Present Value (NPV) measures how much value an investment or project is expected to create, expressed in today’s money. It discounts all future cash inflows back to the present using a chosen rate and subtracts the initial investment. A positive NPV signals a worthwhile project; a negative NPV signals one to avoid.

How does it work?

Money received in the future is worth less than money today, so each year’s cash inflow is divided by a growing discount factor. The calculator sums these present values, subtracts the upfront cost, and reports the NPV along with a profitability index (present value of inflows per rupee invested).

Formula

NPV = −C₀ + Σ [ CFₜ / (1 + r)ᵗ ] for t = 1 … n

• C₀ = initial investment (cash outflow at t = 0)
• CFₜ = cash inflow in year t
• r = discount rate (cost of capital)
• n = number of years

Example calculation

Benefits

• ✓Accounts for the time value of money, unlike a simple payback.
• ✓Gives a clear accept/reject rule: take projects with NPV ≥ 0.
• ✓Allows comparison of projects with different cash-flow patterns.

Limitations

• !Highly sensitive to the chosen discount rate.
• !Relies on uncertain forecasts of future cash flows.
• !Does not by itself indicate the scale or timing risk of a project.

Conclusion

NPV is the gold standard for capital-budgeting decisions because it directly measures value creation. Test a range of discount rates and cash-flow scenarios to understand how robust your decision is before committing capital.