Guide to the Profitability Index (PI)?
By Markets & Investing DeskUpdated Nov 10, 2026
Definition
The profitability index (PI) is a capital budgeting ratio that divides the present value of a project's future cash flows by its initial investment. A PI above 1.0 signals a positive NPV.
Key takeaways
- PI = present value of future cash flows ÷ initial investment.
- A PI of 1.0 is the break-even point, where net present value (NPV) equals zero.
- Because the cash flows are discounted, PI accounts for the time value of money.
- PI measures value per dollar invested, which makes it useful for ranking projects when capital is limited.
- PI ignores project size, so a high-PI project can create less total value than a larger project with a lower PI.
The profitability index (PI) is a capital budgeting ratio that divides the present value of a project’s expected future cash flows by its initial investment. It shows how much discounted value a project is expected to return for each dollar put in at the start. A PI above 1.0 means the discounted cash flows exceed the upfront cost. A PI below 1.0 means they fall short. In finance, PI stands for profitability index. The same measure is also called the benefit-cost ratio.
What the profitability index measures
Most capital budgeting tools answer one of two questions: how much value a project creates in total, or how efficiently it uses the money invested. Net present value answers the first in dollars. The profitability index answers the second as a ratio.
That difference is why companies reach for PI when they have more acceptable projects than funds to pay for them. If a firm can spend only a fixed amount this year, the useful question becomes which projects deliver the most present value per dollar of that budget.
Profitability index formula
The standard formula is:
PI = PV of future cash flows ÷ initial investment
The present value of future cash flows is calculated with discounted cash flow arithmetic:
PV = CF₁/(1 + r)¹ + CF₂/(1 + r)² + … + CFₙ/(1 + r)ⁿ
where:
- CF is the net cash flow expected in a given year
- r is the discount rate, usually the company’s required return or its weighted average cost of capital
- n is the number of periods
The numerator captures the time value of money. A dollar received in five years is worth less than a dollar today, because today’s dollar could be invested and earn a return in the meantime. Discounting converts every future cash flow into today’s terms so it can be compared with the cost paid now.
The denominator is the cash outflow at the start of the project. Later outflows, such as additional capital spending, along with tax effects and the tax benefit of depreciation, are usually netted into the yearly cash flows in the numerator.
Because NPV equals the PV of future cash flows minus the initial investment, PI can also be written as:
PI = 1 + (NPV ÷ initial investment)
This form shows the link directly: a positive NPV always produces a PI above 1.0, and a negative NPV always produces a PI below 1.0.
How to interpret the profitability index
| PI result | NPV | Meaning |
|---|---|---|
| Greater than 1.0 | Positive | Discounted inflows exceed the initial cost; the project earns more than the discount rate |
| Equal to 1.0 | Zero | The project earns exactly the discount rate |
| Less than 1.0 | Negative | Discounted inflows do not recover the initial cost at the required return |
A PI of 1.25 means the project is expected to return $1.25 of present value for every $1.00 invested, or $0.25 of NPV per dollar. A PI of 0.80 means it returns only $0.80 of present value per dollar, so it destroys value at the chosen discount rate.
There is no universal “good” PI beyond the 1.0 threshold. Higher values indicate a more efficient use of capital, but the figure is only as reliable as the cash flow forecasts and discount rate behind it. A project with a PI just above 1.0 can drop below it if the forecasts turn out slightly too optimistic.
For a project with conventional cash flows (one outflow followed by inflows), PI above 1.0 also means the internal rate of return is above the discount rate. All three measures give the same accept or reject answer for a single independent project. They can disagree when projects are ranked against each other.
Example of the profitability index
Hypothetical example. A company uses a 10% discount rate and is evaluating two independent five-year projects. Each produces equal annual cash flows, so the PV can be calculated with the five-year annuity factor at 10%, which is 3.7908 (the sum of 1/1.10 through 1/1.10⁵).
Project A
- Initial investment: $100,000
- Annual cash flow: $30,000
- PV = $30,000 × 3.7908 = $113,724
- PI = $113,724 ÷ $100,000 = 1.14
- NPV = $13,724
Project B
- Initial investment: $400,000
- Annual cash flow: $115,000
- PV = $115,000 × 3.7908 = $435,941
- PI = $435,941 ÷ $400,000 = 1.09
- NPV = $35,941
Both projects pass the 1.0 test. Project A uses capital more efficiently, returning $1.14 per dollar against Project B’s $1.09. Project B, however, creates more than twice as much total value. If the company has enough capital to fund both, it should accept both, since each has a positive NPV. The ranking only matters when funds are limited or the projects are mutually exclusive.
How companies use the profitability index
Ranking projects under capital rationing
When a company has a fixed capital budget, it can rank projects by PI and fund them from the top down until the budget runs out. Continuing the hypothetical, add a third project:
- Project C: costs $300,000, PV of $345,000, PI of 1.15, NPV of $45,000
With a $400,000 budget, the PI ranking is C (1.15), A (1.14), then B (1.09). Funding C and A uses exactly $400,000 and produces a combined NPV of $58,724. Funding B alone would use the same budget and produce only $35,941. Here, ranking by PI leads to the better portfolio.
Screening and comparing alternatives
PI also works as a quick screen: any project below 1.0 is rejected before further analysis. Because it is a ratio, it lets managers compare proposals of different sizes and lifespans on a common per-dollar basis. It is typically used alongside NPV, IRR and payback period rather than as the only decision rule.
Limitations of the profitability index
It ignores scale. PI says nothing about the absolute dollar value created. When projects are mutually exclusive, such as two ways of using the same site, the project with the higher NPV adds more to shareholder value even if its PI is lower. Project B above would beat Project A in that situation.
Ranking assumes projects can be split. The capital rationing method works cleanly only when projects are divisible or the budget happens to fit. Consider a hypothetical $400,000 budget with two options: Project X costs $100,000 with an NPV of $20,000 (PI 1.20), and Project Y costs $400,000 with an NPV of $60,000 (PI 1.15). Ranking by PI picks X and leaves $300,000 idle, earning $20,000 of NPV. Choosing Y earns $60,000. With indivisible projects, the right approach is to compare the total NPV of each feasible combination.
Results depend on how cash flows are classified. If a later outflow is moved from the numerator (netted against inflows) into the denominator (treated as part of the investment), the PI changes even though the NPV does not. Two analysts can report different PIs for the same project, so comparisons are only meaningful when the method is consistent.
It inherits forecast and discount rate risk. Every input is an estimate. A higher discount rate lowers the PV of future cash flows and pulls the PI down, with long-dated cash flows hit hardest. Uncertain forecasts can make a precise-looking ratio misleading.
It is a single-period tool. Simple PI ranking assumes the capital constraint applies once. When budgets are limited across several years, or projects depend on one another, more complex methods such as linear programming are needed.
Profitability index vs. related measures
- PI vs. NPV: NPV measures total value in dollars; PI measures value per dollar invested. They always agree on whether a single project is acceptable, but can rank projects differently.
- PI vs. IRR: IRR is the discount rate at which NPV equals zero, expressed as a percentage. PI uses a chosen discount rate and expresses the result as a ratio. IRR can produce multiple answers for unconventional cash flows; PI does not have that problem.
- PI vs. return on equity: ROE is an accounting ratio that measures historical profitability for shareholders using reported net income. PI is forward-looking and based on projected cash flows, not accounting profit.
FAQs
How do you calculate the profitability index in Excel?
Use =NPV(rate, cash_flow_range) / initial_investment, where the cash flow range covers years 1 through n. Excel's NPV function treats the first value in the range as arriving one period from now, so the initial investment at time zero should be left out of the range and entered separately as the divisor. With the Project A inputs, =NPV(10%, B2:B6)/100000 returns about 1.14.
Can the profitability index be negative?
Yes, but only if the present value of the future cash flows is itself negative, meaning the project is expected to lose money in every discounted sense after the initial outlay. In practice, most results fall between zero and somewhat above 1.0, and anything below 1.0 already signals rejection.
The Bottom Line
The profitability index matters most to managers and analysts choosing among projects when capital is limited, since it shows the present value earned per dollar invested. Any project with a PI above 1.0 has a positive NPV and is worth funding if the budget allows. When projects are mutually exclusive or cannot be split, compare total NPV instead, because a higher PI can still mean less total value.
