Skip to content
Omnikalc

Profitability index calculator: how much value per dollar invested?

Enter the investment, the yearly cash inflow, the years and the discount rate to get the present value, the profitability index, the NPV and the payback.

Updated on
Your inputs
$

Value out of range

$

Value out of range

Value out of range

%

Value out of range

Results

Profitability index

1.061

Worth pursuing: the index is above 1
Present value of the inflows
$106,142
Net present value
$6,142
Simple payback
3.57 years

When money is limited, the question is not only if a project pays off but how much value it gives per dollar invested. This profitability index calculator takes the initial investment, the annual cash inflow, the number of years and the discount rate to give the present value of the inflows, the profitability index, the net present value and the simple payback.

How the calculation works

  • Present value of the inflows = annual cash flow × (1 − (1 + r)^−n) ÷ r, where r is the discount rate and n the number of years.
  • Profitability index PI = present value of the inflows ÷ initial investment. A PI above 1 means that the project returns more than it costs, in present-value terms.
  • Net present value = present value of the inflows − initial investment. A PI above 1 matches a positive NPV.
  • Simple payback = initial investment ÷ annual cash flow, the time to recover the outlay without discounting.

Example

A project costs $100,000 and brings $28,000 a year for 5 years, at a discount rate of 10%. The present value of the inflows is 28,000 × 3.7908 = $106,142. The profitability index is 106,142 ÷ 100,000 = 1.061, and the net present value is $6,142. The simple payback is 3.57 years.

Why it matters

Finance students, business owners and analysts use the index to compare projects of different sizes and to ration a budget. It gives a quick answer to the question of whether an investment returns more than it costs after the time value of money.

Good to know

The calculator assumes a single outlay at the start and an equal cash inflow at the end of each year, with no residual value, taxes or inflation changes. Real cash flows are uneven and uncertain, and the discount rate is a judgment. The index is one tool, and large decisions need a full model and professional advice. This is not investment advice.

The net present value calculator gives the value in dollars, the IRR calculator finds the rate of return and the payback period calculator shows how long it takes to recover the cost.

Frequently asked questions

What is the profitability index?

It is the present value of the future cash flows divided by the initial investment. A value of 1.10 means that every dollar invested brings $1.10 in today's money. It is also called the benefit-cost ratio, and a project is acceptable when the index is above 1.

How does it differ from NPV?

The NPV is a sum in dollars and the profitability index is a ratio. Both agree on whether a project is good, but the ratio is better for ranking projects when the money is limited, since it shows the value created per unit invested. A large project can have a big NPV and a low index.

Which discount rate should I use?

Use the rate of return that you could earn on an investment of similar risk, or the cost of capital of your company. A higher rate lowers the present value and the index. It is wise to test a few rates to see how sensitive the result is.

What are the limits of the index?

It assumes that the cash flows are known and equal each year. Real projects have uneven flows, risks and a residual value, and the index may rank projects in a different order from NPV when they differ in size or timing. Use it with other measures such as the NPV and the IRR.

Was this calculator helpful?

Thanks for your feedback!

Results are estimates provided for information purposes. They do not replace professional advice.