analyticsNPV / IRR / Present Value Calculator

Net Present Value, Internal Rate of Return and Present Value for investment decisions

edit_calendar Last updated: Jul 22, 2026 | verified Reviewed by Calkulator Team | timer 2 min read
Investment illustration
Investment

Make capital budgeting decisions with NPV and IRR

Should your business invest ₹10 lakh in a new machine that generates ₹3 lakh/year for 5 years? NPV tells you if the investment adds value at your required return rate. IRR shows the effective return rate — accept if IRR exceeds your hurdle rate.

tips_and_updates Use NPV over IRR when comparing mutually exclusive projects — IRR can give misleading results for unequal cash flows.

Calculation Mode

percent
currency_rupee

Cash Flows (Year 1–6, can be negative):

Formulas

NPV: S [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

Result
Decision
insights
Live Result Illustration
Visual summary — updates instantly as you enter values above
LIVE
Investment Growth Summary Enter values above to update Invested ₹18 L Amount Total Corpus ₹50.5 L Maturity Total Gains ₹32.5 L Returns on Investment +180% Start early — 5 extra years can nearly double your corpus through the power of compounding.
tips_and_updates

Real-Life Guide to Using the NPV / IRR Calculator

Project viability and returns. Use the examples and checks below to turn the number into a practical decision.

When this calculator is useful

Aimed at evaluating whether a specific project or business investment is worth undertaking — for example putting ₹10,00,000 into a new small business venture and comparing the expected future cash flows against what that money could otherwise earn.

For most people, the best way to use the NPV / IRR Calculator is to try the real case first, then change one input at a time. That makes the trade-off visible. For example, with a loan calculator you can change tenure while keeping the same rate; with an investment calculator you can change return assumption while keeping the same monthly contribution; with a health, education or measurement calculator you can check how much one input changes the final category.

The result should answer a practical question: Can I afford this? How much should I save? Is this score enough? Is this measurement within range? What is the safer or cheaper option? If the output does not answer the decision clearly, adjust the inputs until the scenario matches your real situation.

lightbulb Real-Life Example
Small business investment appraisal: An entrepreneur is deciding whether to invest ₹10,00,000 in new equipment expected to generate ₹3,00,000 in net cash flow every year for the next 5 years.
1At a 10% discount rate, the present value of the five ₹3,00,000 cash flows totals approximately ₹11,37,000, giving an NPV of about ₹1,37,000 (11,37,000 – 10,00,000) — a positive number, so the project clears the 10% hurdle. Solving for the rate where NPV hits zero gives an IRR of just over 15%, meaning the investment would still break even even if the true cost of capital were as high as that.
2Now change one input, such as rate, time, quantity, unit or score, and compare the new result with the first one.
A positive NPV plus an IRR comfortably above your cost of capital together give more confidence in a project than either number alone.

Practical Advice

Use the NPV / IRR Calculator as a planning tool, not just a number generator. Write down the inputs you used, because the final answer is meaningful only when you remember the assumptions behind it.

If the decision affects money, health, tax, safety, academics or legal compliance, keep a second check ready. That second check may be a bank quote, payslip, official rule, prescription, site measurement, mark sheet or invoice.

Common Mistakes

  • Choosing a discount rate that does not reflect the actual cost of capital or opportunity cost — using a flat 10% when the money would otherwise be earning 12% elsewhere overstates the project's attractiveness.
  • Treating NPV and IRR as if they always agree — with unconventional or multiple sign-changing cash flows, IRR can produce more than one mathematically valid answer or none at all, while NPV at your chosen rate remains a single reliable figure.
  • Forgetting to include the initial investment as a cash outflow at time zero, a common data-entry mistake that throws off both NPV and IRR entirely.
  • Comparing IRR across two projects of very different sizes without also checking NPV — a project with a high IRR on a small investment can create far less actual wealth than a project with a lower IRR on a much larger investment.
  • Ignoring the working capital or terminal value cash flow at the end of the project period, understating the total returns the project is expected to generate.

How to Interpret Results

A positive NPV at your chosen discount rate means the project is expected to create value over and above that rate, while IRR tells you the break-even discount rate itself — compare IRR against your actual cost of capital or best alternative return to decide if the margin of safety is comfortable.

A good interpretation looks at both the main result and the supporting values. If a page shows totals, ratios, categories, schedules or warnings, read those together instead of focusing only on the biggest number.

quiz

NPV / IRR Calculator FAQs

Useful answers for interpreting the output, avoiding mistakes and using the result responsibly.

What exactly do NPV and IRR measure?
NPV (Net Present Value) discounts every future cash flow back to today's rupees at a chosen rate and sums them, telling you the rupee value a project adds over your required return; IRR (Internal Rate of Return) is the specific discount rate at which that NPV works out to exactly zero.
What discount rate should I actually enter for NPV?
Use your cost of capital, borrowing rate, or the best alternative return you could otherwise earn on that money — there is no universal correct figure, so the choice should reflect your own realistic opportunity cost.
If NPV is positive but IRR looks lower than I expected, which should I trust?
Trust NPV for the actual rupee decision, since NPV directly answers whether the project creates value at your required rate, while IRR is best used as a supporting sanity check, especially useful for comparing projects of similar size.
Can IRR give a strange or multiple answer?
Yes — if the project's cash flows change sign more than once (for example, a large cash outflow appears again midway through, such as a major refurbishment), the underlying equation can mathematically have more than one IRR or none, in which case NPV at your actual rate is the more dependable figure.
How is this different from XIRR?
XIRR is specifically for actual dated cash flows (real calendar dates, uneven gaps) typically used for personal investments; NPV/IRR here assumes evenly spaced periods (usually annual) and is the standard method for business project appraisal and capital budgeting decisions.
Does a higher IRR always mean a better project?
Not necessarily — IRR does not reflect the scale of the investment, so a tiny project with a 40% IRR may generate far less actual profit than a large project with a 15% IRR; always check NPV in rupee terms alongside IRR before deciding.
Should the cash flows I enter be before or after tax?
For a realistic business decision, use after-tax cash flows wherever possible, since tax materially affects the actual money the project generates and leaves for reinvestment or distribution.
What if my project has an uneven or irregular cash flow pattern, not equal yearly amounts?
That is fine — NPV can handle different cash flow amounts in each period as long as you enter them period by period; just be consistent about the length of each period (monthly, quarterly, or annual) throughout the calculation.

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)4 + 3L/(1.12)5
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

  1. 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).
  2. 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).
  3. 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.
  4. 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.
  5. 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.
keyboard_arrow_up