NPV Calculator — Net Present Value for Investment Decisions
Calculate Net Present Value (NPV) for any investment or project. Determine if future cash flows justify today's investment at your required return rate.
NPV is the gold standard for capital budgeting decisions. It answers one question with precision: given your required rate of return, does this investment create or destroy value? A positive NPV means yes; negative means the capital is better deployed elsewhere. The CalcHub NPV Calculator handles the discounting math across any number of periods.
The Formula
NPV = −Initial Investment + Σ [Cash Flow_t / (1 + r)^t]Where:
- r = discount rate (your required return or cost of capital)
- t = time period (year 1, year 2, etc.)
- Cash Flow_t = net cash inflow in period t
The discount rate is the key variable. It represents what you could earn in your next best alternative, or your company's weighted average cost of capital (WACC).
A Complete Example
A startup is considering building a new product feature. Upfront cost: ₹12,00,000. Expected additional cash flows over 5 years:
| Year | Cash Flow | Discount Factor (10%) | PV of Cash Flow |
|---|---|---|---|
| 1 | ₹2,50,000 | 0.909 | ₹2,27,250 |
| 2 | ₹3,50,000 | 0.826 | ₹2,89,100 |
| 3 | ₹4,00,000 | 0.751 | ₹3,00,400 |
| 4 | ₹4,50,000 | 0.683 | ₹3,07,350 |
| 5 | ₹5,00,000 | 0.621 | ₹3,10,500 |
| Sum of PVs | ₹14,34,600 |
Positive NPV of ₹2.34L at 10% discount rate — the project creates value. Build it.
Choosing the Right Discount Rate
This is where most NPV analyses go wrong. Common approaches:
- WACC (Weighted Average Cost of Capital) — best for established businesses evaluating investments that match their risk profile
- Hurdle rate — some companies set a minimum required return (e.g., 15%) for any investment to be approved
- Risk-adjusted rate — higher-risk projects use higher discount rates. A fintech startup might use 20–25%; a government infrastructure project might use 6–8%
NPV Sensitivity: Same Project, Different Discount Rates
| Discount Rate | NPV |
|---|---|
| 5% | +₹5,10,000 (approx) |
| 10% | +₹2,34,600 |
| 15% | +₹11,000 (barely positive) |
| 20% | −₹1,95,000 (negative) |
How to Use the Calculator
- Enter initial investment (as a negative cash flow in Year 0)
- Enter expected cash flows for each year (up to 10+ years)
- Enter discount rate (annual %)
- Get NPV, total undiscounted cash flow, and total PV of future cash flows
NPV vs IRR: Which to Use?
NPV tells you the absolute value created in today's rupees. IRR tells you the percentage return. For comparing mutually exclusive projects of different sizes, NPV is more reliable — a small project with very high IRR may create less total value than a larger project with lower IRR but higher NPV.
What does a zero NPV mean?
Zero NPV means the investment exactly meets your required return rate — not more, not less. It's not a bad investment (you're earning your cost of capital), but it creates no economic profit above that threshold. In practice, zero-NPV projects may not be worth pursuing because estimates are imprecise and there's no buffer for errors.
How do I estimate cash flows for NPV?
Project revenue growth from realistic assumptions about market size, pricing, and adoption. Subtract all incremental operating costs the project requires. Be conservative on timing — revenue usually comes in slower than planned, costs arrive faster. Consider running optimistic, base, and pessimistic scenarios with different cash flow projections.
Can NPV be used for personal finance decisions?
Yes, and it's underused. Buying a car vs leasing, paying off a loan early vs investing the difference, taking a higher-paying job requiring relocation — all of these involve future cash flows and can be modeled with NPV. The discount rate for personal decisions is often your opportunity cost (e.g., expected return on your investment portfolio).