Profitability Index Calculator
This profitability index calculator divides the present value of future cash flows by the initial investment to show whether a project creates value.
What it does
The Profitability Index Calculator measures how much value a project creates per unit of money invested. It divides the present value of a project's expected future cash flows by the upfront cost, giving a single ratio that tells you whether the investment is worth making.
Data sources & parameters
This calculator uses standard financial formulas and runs entirely in your browser. It needs no external rate data — your result is computed only from the values you enter above.
We always strive to use the latest data for every variable so our results and reports are as accurate as possible. Even so, errors are possible — you should not rely on this tool or its report alone, and we accept no liability for any decision made based on it.
The formula
PI = PV of future cash flows ÷ initial investment; NPV = PV of future cash flows − initial investment
How it works
Enter the present value of the future cash flows the project should generate and the initial investment it requires. The tool divides one by the other to produce the profitability index, subtracts the outlay to show the net present value, and flags whether the index clears the 1.0 acceptance threshold.
Where it is used
- Ranking competing projects when capital is limited
- Confirming an accept or reject decision alongside NPV
- Comparing investments of different sizes on a like-for-like basis
Worked example
A project needs $100,000.00 upfront and its future cash flows are worth $113,723.60 today. The profitability index is …, the net present value is …, and because the index is at or above 1.0 the decision flag reads … — accept.
What the profitability index calculator does
The profitability index calculator measures how much value an investment creates for every unit of money you commit. It divides the present value of a project's expected future cash flows by the initial investment. A result of exactly 1.0 means the project breaks even in present-value terms; above 1.0 it creates value, and below 1.0 it destroys value.
The tool also shows the net present value and an accept-or-reject signal, so you see both the ratio and the currency amount behind it.
How the profitability index works
Money received in the future is worth less than money today, because today's money can be invested to earn a return. To compare future cash flows with money spent now, the future flows are first discounted to their present value, and the profitability index relates that present value to the amount invested.
The profitability index equals the present value of future cash flows divided by the initial investment. A project expected to return cash worth 113,700 today that costs 100,000 to start has an index of about 1.14: each unit invested returns roughly 1.14 units in present-value terms, about fourteen percent above break-even.
Net present value is the same relationship expressed as a subtraction: the present value of future cash flows minus the initial investment. The two always point to the same decision. An index above 1.0 means a positive net present value, below 1.0 a negative one, and exactly 1.0 a net present value of zero.
Why the ratio matters
Net present value is an absolute measure, so a large project often shows a bigger figure than a small one simply because more money is involved. The profitability index scales value against cost, so a small project with an index of 1.4 generates more value per unit invested than a large project with an index of 1.1, even if the large one has a bigger net present value. When money is the binding constraint, that efficiency matters.
Using the calculator
Enter the present value of the future cash flows the project is expected to generate, already discounted to today at a rate that reflects the project's risk and your cost of capital. Then enter the initial investment, the upfront outlay.
The calculator gives the profitability index, the net present value, and a decision flag that reads one when the index reaches 1.0 and zero when it falls short. The chart sets the initial investment next to the present value of future cash flows.
Reading the results
The index is only as accurate as the present value you enter, which depends on your cash flow forecasts and the discount rate. A small change in the discount rate can move the present value considerably, so test a conservative rate and an optimistic one to see how sensitive the decision is.
With several candidate projects and a limited budget, rank them by index and fund projects down the list until the money runs out. This usually produces more total value than choosing on net present value alone, because it favours investments that stretch each unit of capital furthest. Where projects are mutually exclusive instead of competing for a shared budget, net present value decides, since the goal there is to maximise total value.
Common mistakes
Entering undiscounted cash flows overstates the project's worth, because the tool expects a present value. An inappropriate discount rate also distorts the result: too low and every project looks attractive, too high and worthwhile ones get rejected. And a single index is not a full analysis; it says nothing about strategic fit, execution risk, or how reliable the underlying forecasts are.
This article is general information only and is not financial advice.
About This Profitability Index Calculator
Use this profitability index calculator to get an instant estimate based on the figures you enter. Adjust the inputs above to match your situation, or browse all our calculators to plan your next step.
Frequently asked questions
How does the profitability index calculator work?
What is a good profitability index?
How is the profitability index different from NPV?
When should I use the profitability index?
Does the calculator discount the cash flows for me?
About the author
