NPV Calculator with Profitability Index and Terminal Value

What NPV Is and Why It Is the Gold Standard

Net present value, or NPV, is the single most trusted measure in capital budgeting, the discipline of deciding whether a project or investment is worth its cost. It answers the question every investor and manager ultimately asks: after accounting for the time value of money, does this project create more value than it consumes? NPV gives that answer in rupees, a concrete figure for the value the project adds today, which is why finance textbooks call it the gold standard for investment decisions.

The idea rests on a simple truth: a rupee today is worth more than a rupee next year, because today’s rupee can be invested to earn a return. So a cash flow expected in five years is worth less than the same amount now, and to compare cash flows arriving at different times fairly, you must discount each future flow back to its present value. NPV does exactly this: it discounts every future cash flow to today at your chosen rate, sums them, and subtracts the initial investment. If the total is positive, the project earns more than your required return and creates value; if negative, it destroys value.

The discount rate is the heart of the calculation, and choosing it well is essential. It represents your required rate of return, the minimum you demand to tie up your money, and for a company it is usually the weighted average cost of capital, or WACC, the blended cost of its debt and equity. A common rule of thumb is around ten per cent for an average-risk project, eight for low risk, and twelve to fifteen for high risk. The rate matters enormously because it is the bar the project must clear, and because NPV is sensitive to it, a small change in the rate can flip a project from accept to reject, which is why this tool shows you the sensitivity.

What makes NPV superior to simpler measures is that it is absolute and unambiguous. Unlike the internal rate of return, which is a percentage that ignores the scale of a project and can produce multiple or misleading values, NPV gives a single rupee figure that directly measures value created and always points the same way: positive means accept, negative means reject. It also, unlike the payback period, counts every cash flow across the whole life of the project, not just those up to the point of recovering your outlay. For a sound decision, NPV is the measure to lead with, which is what this tool is built around.

Profitability Index, Terminal Value and the Full Picture

NPV tells you whether a project creates value and how much, but it does not, on its own, tell you how efficiently it uses your capital, and that gap is where the profitability index comes in. The profitability index, or PI, is the present value of a project’s future cash flows divided by its initial investment. A PI above one means the project creates value, exactly the same conclusion as a positive NPV, so the two always agree on whether to accept a single project. Where they differ is in ranking: PI measures value created per rupee invested, an efficiency ratio, while NPV measures total value, an absolute amount.

This distinction becomes crucial under capital rationing, when you have more good projects than money to fund them. With unlimited capital you simply accept every positive-NPV project. But with a fixed budget you must choose, and here PI is the right guide, because it tells you which projects squeeze the most value out of each scarce rupee. A small project with a high PI may create less total value than a large one with a lower PI, yet be the better choice when capital is tight, because you can fund it and still have money left for others. This tool computes both NPV and PI, so you can rank by absolute value when capital is free and by efficiency when it is constrained.

There is a second gap that most NPV calculators leave open, and it can badly understate a project: the terminal value. Real projects rarely stop cleanly at the end of the years you can forecast. A factory keeps producing, a property can be sold, equipment has salvage value, a business has an ongoing worth beyond the explicit forecast. The terminal value captures all of that: it is the value of the project’s cash flows continuing beyond your forecast horizon, usually estimated as a growing perpetuity of the final cash flow. Leaving it out, as many tools force you to, treats the project as if it simply vanishes at the end, which can hugely undervalue it.

This tool lets you add a terminal value as an option, estimating the worth of the cash flows continuing forever at a modest growth rate below your discount rate, and discounting that back into the NPV. For a project with a long or indefinite life, this often transforms the result, turning a marginal-looking NPV into a clearly positive one, because so much of a long-lived project’s value sits in its later years. Together, NPV for the decision, PI for capital-efficient ranking, and terminal value for the project’s full worth, with IRR and discounted payback as supporting checks, give you the complete capital-budgeting picture rather than a single, potentially misleading figure.

A word on how these measures behave together in practice. For a straightforward project, NPV, PI and IRR will point the same way, and the extra measures simply add confidence: PI tells you the efficiency, IRR confirms the rate clears your bar, discounted payback flags how long your capital is exposed. The value of seeing them side by side is greatest at the margins, when a project is close to break-even, or when you are choosing between several, or when the discount rate is uncertain. That is exactly when a single number can deceive and a fuller view earns its keep, which is why this tool presents the whole set rather than leaving you to judge a consequential decision on one figure alone.

How the Metrics Are Calculated

The tool computes the full discounted-cash-flow analysis from your inputs, in four steps.

Step one: discount every cash flow

It takes your initial investment as the year-zero outflow and each future cash flow you enter, then discounts each one back to today by dividing it by one plus the discount rate raised to the power of its year. This converts every future rupee into its worth in today’s money, so that flows arriving at different times can be added together fairly. Because you enter each year separately, the tool handles uneven cash flows without assuming they are equal.

Step two: compute NPV and the profitability index

It sums all the discounted cash flows, including the negative initial outlay, to get the NPV, the net value the project creates today. It also divides the present value of the future inflows by the initial investment to get the profitability index. A positive NPV and a PI above one both signal a value-creating project; the tool gives a clear accept or reject verdict based on the NPV.

Step three: add the terminal value if chosen

If you opt for a terminal value, the tool treats the final year’s cash flow as continuing forever, growing at the modest rate you set, and values that perpetuity using the standard growing-perpetuity formula, the final flow times one plus growth, divided by the discount rate minus the growth rate. It discounts this terminal value back to today and folds it into the NPV, capturing the project’s worth beyond the years you forecast. It requires the growth rate to be below the discount rate, since otherwise the perpetuity has no finite value.

Step four: IRR, payback and sensitivity

Finally it computes the IRR, the rate at which NPV would be zero, as a supporting check that the project clears your rate, using a robust method that also flags the rare multiple-IRR case. It works out the discounted payback period, how long until your discounted cumulative cash flow turns positive, and it runs a sensitivity table showing how the NPV and the accept or reject decision change as the discount rate varies, since NPV can be sensitive to that rate.

NPV, PI and Discount Rate Guidance

These reference points explain the formulas, the decision rules and how to pick a discount rate.

The formulas

The decision rules

Choosing a discount rate

Three Worked Examples From Real Decisions

Here are three decision-makers using NPV to judge a project properly.

Arun evaluates a factory expansion in Pune

Arun is weighing a one lakh expansion at his Pune unit that should bring in about thirty thousand a year for five years. On the tool, at his ten per cent cost of capital, the NPV came out clearly positive and the profitability index above one, both saying accept. The IRR, shown alongside, comfortably beat his ten per cent rate, confirming the decision.

When Arun added a terminal value, recognising that the expanded capacity would keep earning beyond the five years he had forecast, the NPV jumped substantially, because so much of the value lay in the project’s continuing life. Arun approved the expansion, confident that on the full picture, including the worth beyond his forecast, it created real value. What impressed him was how large the terminal value’s contribution was: without it, he had been implicitly assuming the new capacity would stop earning the moment his five-year forecast ended, which was plainly unrealistic for a factory that would run for decades. Including it turned a merely acceptable project into an obviously strong one, and taught him never to truncate a long-lived project at his forecast horizon.

Meera rations capital between projects in Mumbai

Meera, in Mumbai, had two positive-NPV projects but only enough budget for one. The larger project had a higher NPV in absolute rupees, but the smaller one had a higher profitability index. On the tool she saw the distinction clearly: the large project created more total value, but the small one created more value per rupee invested. Because her capital was constrained, Meera reasoned that funding the more efficient project would leave money to put toward other opportunities, and the tool’s PI guided her ranking.

She chose based on the profitability index, understanding that under a fixed budget, efficiency per rupee, not absolute NPV, is the right criterion. The episode clarified a distinction she had previously blurred. She had always reached for the highest NPV, assuming more value was always better, but the tool showed her that this logic only holds when capital is free. With a hard budget, the residual money left over after funding an efficient project could itself be deployed into further positive-NPV opportunities, so the efficient choice compounded its advantage. She resolved to check the PI whenever her capital was the binding constraint, and the NPV whenever it was not.

Rakesh tests the discount rate in Bengaluru

Rakesh, in Bengaluru, had a project that looked healthy at an eight per cent discount rate, with a solidly positive NPV. But he was unsure whether eight per cent truly reflected his cost of capital, which might be higher given the project’s risk. On the tool, the sensitivity table showed him how the NPV fell as the rate rose, and at twelve per cent the NPV turned negative, flipping the decision from accept to reject.

Rakesh realised how much the verdict hinged on the rate he chose, and he took care to justify a rate that properly reflected the risk before committing. The sensitivity view saved him from approving a project on an over-optimistic rate. It also changed how he presented projects to his board: rather than quoting a single NPV that could be quietly engineered by picking a flattering rate, he now shows the NPV across a band of rates, so the decision-makers can see for themselves how fragile or robust the case is. A project whose NPV stays positive across the whole plausible range of rates is a genuinely safe bet; one that flips within that range demands a hard, honest look at the discount rate before any money is committed.

Six Tips for Using NPV Well

Frequently Asked Questions on NPV

Related Calculators You May Find Useful