ToolSphere

NPV & IRR Calculator

Business and money

Calculate Net Present Value (NPV) and Internal Rate of Return (IRR) for capital budgeting and investment cash flows with customizable discount rates.

NPV & IRR Calculator

Enter cash flows starting with period 0 (typically the initial investment, as a negative number), followed by each subsequent period's cash flow.

NPV at 10%
1,428.86
IRR
16.2652%
NPV is positive — the project exceeds the required return at this discount rate.

On this browser only

Give feedback

Did this tool help?

Tell us what worked, what didn’t, or what you’d like next.

Opens Google Forms in a new tab with this tool’s name filled in. No sign-in or email required. Feedback is optional.

About NPV & IRR Calculator

NPV & IRR Calculator

Computes Net Present Value (NPV) — the sum of all cash flows discounted back to today's value — at a rate you specify, and Internal Rate of Return (IRR) — the discount rate at which NPV equals exactly zero, found numerically via bisection search.

A positive NPV at your required rate of return means the project is expected to exceed that return; a negative NPV means it falls short.

Why a rupee today is not a rupee next year

Discounting exists because money has a time value: capital tied up in one project cannot earn elsewhere, and future money carries risk that present money does not. NPV expresses every future cash flow in today's terms and adds them up. A positive NPV means the project earns more than your discount rate demands; a negative one means the same money would do better elsewhere.

The discount rate is therefore the most consequential input, and it is a judgement rather than a calculation. Most businesses use their weighted average cost of capital, raised for riskier projects. Change it from 8% to 12% and a marginal project flips from worthwhile to not — which is why you should test a range rather than trusting a single figure.

Where IRR misleads

IRR is attractive because it is a single percentage that needs no assumed discount rate. It has three well-documented failure modes.

Scale blindness. A project returning 50% on ₹1 lakh has a higher IRR than one returning 20% on ₹1 crore, and creates far less value. NPV compares magnitudes; IRR does not.

Multiple roots. If the cash flows change sign more than once — an investment, returns, then a large decommissioning cost — there can be several rates where NPV equals zero, and no single IRR is meaningful.

The reinvestment assumption. IRR implicitly assumes interim cash flows are reinvested at the IRR itself, which is optimistic for a high-IRR project.

When NPV and IRR disagree about which of two projects is better, follow NPV. It measures value created, which is what you are trying to maximise.

What the model does not include

Timing within a period is ignored — cash flows are treated as arriving at period ends. Inflation must be handled consistently: either discount nominal flows at a nominal rate or real flows at a real rate, never a mixture. And tax effects, working-capital movements and terminal value are all outside the calculation and frequently larger than the difference the tool is resolving.

Guides and tutorials

Frequently asked questions

What does it mean if IRR can't be found?

It usually means the cash flow sequence doesn't have a sign change compatible with a single real IRR in the searched range — this can happen with unconventional cash flow patterns (multiple sign changes) that may have multiple or no real IRR solutions.

Should I use NPV or IRR to compare two projects?

NPV is generally considered more reliable for comparing projects of different sizes or cash flow timing, since IRR can rank a smaller project higher purely due to scale even when NPV shows the larger project creates more actual value.

If NPV and IRR disagree, which should I follow?

NPV. It measures the value created in currency terms, which is what you are maximising. IRR is scale-blind — a high percentage on a small project beats nothing on a large one only in the ratio, not in money.

Why can IRR sometimes not be calculated?

Because IRR is the rate at which NPV crosses zero, and that crossing may not exist or may happen more than once. Cash flows that change sign several times can produce multiple valid IRRs, none of them meaningful on its own.

How do I choose a discount rate?

Most businesses start from their weighted average cost of capital and add a premium for project risk. Because the choice can flip a marginal decision, test a range rather than relying on one figure.

Have a suggestion for NPV & IRR Calculator?Share your feedback ↗