Saved

Press the star next to a tool's name to save it.

All my tools

Profitability Index Calculator

Use this profitability index calculator to divide the present value of a project's cash inflows by the investment and see the NPV and the accept or reject result.

Restored your last values ·

%

Enter the amount invested today, a yearly discount rate and the cash inflows you expect in each of the next years, in order. The first inflow is discounted by one year.

Everything is worked out in your browser. Nothing you type is sent anywhere.

–

–

Fill in the boxes and press Calculate.

A profitability index calculator shows how much value a project creates for each dollar invested. Enter the initial investment, a discount rate and the cash inflows you expect each year, and the calculator discounts the inflows to their present value and divides by the investment. A profitability index above 1 means the project is worth more than it costs. It also shows the net present value and the total of the inflows.

The profitability index formula

PI = present value of future cash flows ÷ initial investment
= 1 + NPV ÷ initial investment

OpenStax's Principles of Finance defines the index as the present value of cash inflows divided by the present value of cash outflows, and its decision rule is to accept a project when the index is above 1. The index can also be written as one plus the net present value divided by the investment. A value of 1 means the project breaks even, and a higher value means a more attractive project. It is useful when capital is limited, because it is a ratio: it ranks projects by value per dollar invested.

How to use the profitability index calculator

  1. Enter the initial investment.
  2. Enter the discount rate as a yearly percentage.
  3. Enter the expected cash inflow for each year, in order.
  4. Press Calculate.

Worked example

For example, a project costs $40,000 and has with a five-year life and expected inflows of $18,000, $12,000, $10,000, $9,000 and $6,000, discounted at 10 percent. The present value of the inflows is about $43,667, so the profitability index is 43,667 ÷ 40,000 = 1.092, and the net present value is about $3,667. Because the index is above 1, the decision is to accept the project. The article rounds its discount factors, which gives a present value of $43,679 and an NPV of $3,679; the calculator uses exact factors, so the figures differ slightly, but the index is the same to three places.

The decision rule

If the profitability index is above 1, the present value of the inflows exceeds the investment, the NPV is positive, and the project adds value. If it is below 1, the project loses value. At exactly 1 it breaks even. For a single project the index and the NPV always give the same accept or reject answer. The difference arises when you compare several projects, because the index measures value per dollar and the NPV measures total value.

When capital is limited

The index is helpful under capital rationing: when you can't fund every worthwhile project, choosing by the highest index gets the most value from the limited money. A small project with an index of 1.4 may be a better use of money than a big one with an index of 1.1, even if the big one has the larger NPV. Rank the projects by index, fund them in order until the money runs out, and then check that the combination makes sense.

Choosing the discount rate

The index depends heavily on the discount rate, which should reflect the project's risk and the return available on other uses of the money. A higher rate lowers the present value and the index. In the example, at 15 percent the present value falls to about $39,430 and the index to 0.99, which turns the decision to reject. Try different rates to see how sensitive the decision is. The WACC calculator helps work out a company-wide rate, and the CAPM calculator an equity return.

Cash flows and timing

Enter the inflows in the order they arrive, one for each year, using net cash flows after tax. The calculator discounts the first by one year, the second by two, and so on, with the investment made today. If your inflows are the same every year, the PVIFA calculator gives the present value with one factor. For a project with later outlays or uneven flows, the DCF calculator handles negative cash flows too.

Limits of the index

The index ignores the scale of the project and the timing of cash flows beyond the discounting. It can also mislead when projects are mutually exclusive: one with a lower index may add more total value. Use it alongside the NPV and the ROI calculator, and test the cash flow estimates, which are the weakest part of any capital budget.

A second worked example

Suppose a project costs 20,000 and returns 8,000 a year for three years, with a discount rate of 8 percent. The present value of the inflows is 8,000 ÷ 1.08 + 8,000 ÷ 1.1664 + 8,000 ÷ 1.2597, which is about 20,617. The profitability index is 20,617 ÷ 20,000 = 1.031 and the net present value is about 617. The project clears the hurdle only narrowly, so a slightly higher discount rate or slightly lower inflows would turn it into a reject. Running the calculator on a few such variations shows how much margin for error the project has.

Entering uneven or zero years

If a year has no inflow, enter 0 for it so that later years are discounted by the right number of periods. Leaving it out would pull every later cash flow one year closer and overstate the present value. The same applies to a year with a loss: enter it as a negative number, which reduces the present value. Keep the list in year order, and check that the number of entries matches the project's life.

Common mistakes

  • Including the investment in the inflows. Enter it separately.
  • Using the wrong rate. Enter a yearly rate for yearly flows.
  • Ignoring risk. A riskier project needs a higher discount rate.
  • Ranking mutually exclusive projects by index alone. Check the NPV too.

What next

Use this often? Add Profitabilit to your Home screen.

Frequently asked questions

How does a profitability index calculator work?

It discounts the cash inflows to present value and divides the total by the initial investment.

What is the PI for $40,000 invested with inflows of 18,000, 12,000, 10,000, 9,000 and 6,000 at 10%?

About 1.092, as in the worked example.

What PI means accept?

Above 1: the present value of the inflows exceeds the investment.

How is PI related to NPV?

PI = 1 + NPV ÷ initial investment.

When is PI most useful?

When capital is limited, because it ranks projects by value per dollar invested.

What went wrong?

We only receive the reason you pick, never what you typed into the tool.

Thanks for your feedback.

More Finance Tools