analyticsNPV / IRR / Present Value Calculator
Net Present Value, Internal Rate of Return and Present Value for investment decisions
Calculation Mode
percent
currency_rupee
Cash Flows (Year 1–6, can be negative):
Formulas
NPV: Σ [CF_t / (1+r)^t] − Initial Investment
IRR: Rate at which NPV = 0 (Newton-Raphson iteration)
Present Value: PV = FV / (1 + r)^n
Discount Factor: 1 / (1+r)^n
Accept project if NPV > 0 or IRR > hurdle rate
What is NPV and IRR?
NPV (Net Present Value) measures the profitability of an investment by discounting all future cash flows back to today's value using a required rate of return (hurdle rate). A positive NPV means the investment creates value; negative NPV means it destroys value. It accounts for the time value of money.
IRR (Internal Rate of Return) is the discount rate that makes the NPV exactly zero — it represents the effective annualised return from the investment. If IRR > your required return (hurdle rate), the investment is worth making. Used by businesses for capital budgeting and project evaluation.
lightbulb Example Calculation
Scenario: ABC Pvt. Ltd. is evaluating a new machine costing ₹10 Lakhs. It generates cash inflows of ₹3 Lakhs/year for 5 years, then ₹0. Hurdle rate = 12% p.a. Should they invest?
1NPV = −10L + 3L/(1.12)¹ + 3L/(1.12)² + 3L/(1.12)³ + 3L/(1.12)⁴ + 3L/(1.12)⁵
2NPV = −10L + 2.679L + 2.392L + 2.135L + 1.906L + 1.702L = −10L + 10.814L = +₹81,400
3Since NPV = +₹81,400 > 0, the investment creates value. IRR ≈ 15.2% > 12% hurdle rate
✓ Result: ABC should invest — the machine generates positive NPV of ₹81,400 and delivers 15.2% IRR, exceeding their 12% hurdle rate.
help_outlineHow to Use the NPV / IRR Calculator
- Select Calculation Mode: NPV (evaluate a project given your required return), IRR (find the effective return rate that makes the project break even), or Present Value (today's value of a future lump sum).
- For NPV: Enter the Discount Rate (your minimum required return), Initial Investment (the upfront cost — enter as positive), and annual cash flows for Years 1–6 (positive = inflow, negative = additional outflow year).
- For IRR: Enter the Initial Investment, your Hurdle Rate (required minimum return), and annual cash flows. The calculator finds the rate at which NPV = 0.
- For Present Value: Enter the Future Value, discount rate, and number of years — to see what that future amount is worth in today's terms.
- Click Calculate to see NPV/IRR result, Accept or Reject recommendation, and a year-by-year cash flow schedule showing the discounting effect.
Benefits
- Makes capital budgeting objective — NPV > 0 = value-creating investment, NPV < 0 = value-destroying
- IRR vs hurdle rate gives a clear single-number accept/reject signal for business projects
- Present Value mode reveals today's worth of any future financial goal (retirement corpus, insurance payout)
- Cash flow schedule shows the discounting effect year by year — shows when the project payback occurs
- Supports negative mid-year cash flows for realistic multi-phase projects (renovation, equipment replacement)
Key Terms
- NPV (Net Present Value)
- Sum of all discounted future cash flows minus the initial investment. NPV > 0: project earns more than required — Accept. NPV < 0: project earns less — Reject. NPV = 0: project exactly meets the required return.
- IRR (Internal Rate of Return)
- The effective annualised return rate from the investment — the discount rate where NPV = 0. If IRR > hurdle rate, the investment clears your minimum return threshold.
- Discount Rate / Hurdle Rate
- Minimum acceptable return rate. For companies: WACC (Weighted Average Cost of Capital). For individuals: opportunity cost (what you could earn elsewhere at similar risk — e.g., equity index fund return).
- Present Value
- Today's equivalent of a future amount: PV = FV / (1+r)^n. ₹1 Crore in 10 years at 10% discount rate is worth only ₹38.55 Lakhs today. Time erodes the value of future money.
- Payback Period
- Number of years to recover the initial investment from cumulative cash flows — simple but ignores time value of money. Use alongside NPV/IRR for a complete picture.
quizFrequently Asked Questions
What is the difference between NPV and IRR — which should I use?
Both are complementary — use both together. NPV tells you the absolute value created (in rupees) at your required return rate. IRR tells you the effective annualised return percentage. NPV is better for: (1) Comparing mutually exclusive projects (higher NPV = better use of capital); (2) When you know your discount rate. IRR is better for: (1) Communicating ROI to stakeholders who think in percentages; (2) Quick go/no-go when IRR clearly exceeds hurdle rate. Pitfall: IRR can be misleading when projects have non-conventional cash flows (multiple sign changes) — multiple IRRs may exist. NPV remains reliable in all scenarios. Always use NPV as the primary decision metric, IRR as supporting context.
How do I determine the right discount rate for NPV analysis?
The discount rate represents the opportunity cost — what you could earn on a risk-equivalent investment. For businesses: use WACC (Weighted Average Cost of Capital) = (Equity% × Cost of Equity) + (Debt% × After-tax Cost of Debt). Cost of equity: use CAPM = Risk-free rate + Beta × Market risk premium. For India: risk-free rate ≈ 10-year G-sec yield (6.5–7%), market risk premium ≈ 6–8%. For personal decisions (property investment, business): use a personal hurdle rate — typically 12–15% for equity-equivalent risk. Conservative rule: use 12% for moderately risky investments (property), 15–20% for highly risky new business ventures, 7–8% for near-certain cash flows (government contracts).
What is a good IRR for a business investment in India?
It depends on the risk level and cost of capital: Startups/early-stage ventures: 25–35%+ IRR expected by angel investors (high risk). VC-backed companies: 25–40%+ IRR for Series A/B investors. Established SME projects: 18–25% IRR (moderate risk). Real estate development: 15–20% IRR (leveraged, 3–5 year horizon). Listed equity investment (passive): 12–15% long-term CAGR expectation. Conservative standard: any investment should at least exceed your cost of capital (WACC) + a risk premium. An IRR below the bank's lending rate (9–11% for working capital) often means the project doesn't justify its financing cost.
Can I use NPV/IRR for personal investment decisions like buying property?
Yes — it's actually very useful for property decisions. Model it as: Initial investment = Down payment + stamp duty + registration. Year 1–N cash flows = Rental income − Property tax − Maintenance − EMI interest component (the true cost of debt). Terminal cash flow (Year N) = Sale price − Remaining loan balance − Capital gains tax − Brokerage. Discount at 12–15% (equity-equivalent return). If NPV > 0, the property investment beats your alternative equity return. Common finding: most residential properties in India have negative NPV when rental yields are 2–3% but equity CAGR is 12%+. Commercial properties (rental yield 6–8%) and holiday rentals often have better NPV.
What happens when a project has multiple IRRs?
Projects with non-conventional cash flows (where cash flows change sign more than once — e.g., negative, then positive, then negative again for decommissioning costs) can mathematically have multiple IRRs, which makes IRR analysis unreliable for those cases. Example: Initial investment -₹10L, Year 1–4 cash flows +₹5L/year, Year 5 cleanup cost -₹8L. This cash flow stream can have 2 IRR solutions. Solution: Use NPV instead for non-conventional cash flows. Or use Modified IRR (MIRR) — which assumes reinvestment at the cost of capital rather than at the IRR itself — producing a unique answer. Excel's MIRR() function calculates this. This calculator uses standard NPV = 0 iteration (Newton-Raphson), which finds the first IRR; use NPV for complex multi-directional cash flows.