analyticsNPV / IRR / Present Value Calculator
Net Present Value, Internal Rate of Return and Present Value for investment decisions
Calculation Mode
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
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.
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.
NPV / IRR Calculator FAQs
Useful answers for interpreting the output, avoiding mistakes and using the result responsibly.
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.
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.