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.