Profitability Index Calculator
Calculate the Profitability Index (PI) to rank and compare investment projects.
Understand when PI beats NPV for capital rationing decisions, with worked examples.
Profitability Index Formula
The Profitability Index (PI) — also called the Benefit-Cost Ratio — measures the value created per dollar of capital invested. It is the NPV-to-investment ratio, normalized to 1.
Formula:
PI = (NPV + Initial Investment) ÷ Initial Investment
Or equivalently:
PI = 1 + (NPV ÷ Initial Investment)
The PI is simply the present value of future cash flows divided by the initial investment.
Decision Rules
| PI Value | Decision |
|---|---|
| PI > 1.0 | Accept — project creates value |
| PI = 1.0 | Break-even — neutral (accept if no better use of capital) |
| PI < 1.0 | Reject — project destroys value |
Calculating NPV from Cash Flows
If you don’t have NPV ready, calculate it first:
NPV = Σ [Cash Flow_t ÷ (1 + r)^t] − Initial Investment
Where:
- r = discount rate (required rate of return / cost of capital)
- t = time period (year 1, 2, 3, …)
- Initial Investment = cash outflow at time zero (negative in NPV)
PI vs NPV vs IRR: When to Use Each
| Method | Best For | Weakness |
|---|---|---|
| NPV | Single project, absolute value | Cannot rank different-sized projects |
| IRR | Return percentage comparison | Can mislead with multiple cash flow signs |
| PI | Capital rationing — ranking many projects by value per dollar | Ignores absolute size of value created |
When PI Is Superior to NPV
Imagine you have $1,000,000 to invest and two choices:
| Project | Investment | NPV | PI |
|---|---|---|---|
| Project A | $800,000 | $240,000 | 1.30 |
| Project B | $300,000 | $120,000 | 1.40 |
| Project C | $300,000 | $105,000 | 1.35 |
NPV alone would pick Project A ($240K). But with $1M to deploy, you can fund B + C = $600K investment generating $225K NPV total — beating A.
PI correctly identifies that B and C create more value per dollar than A. This is capital rationing.
Worked Example
A company is evaluating a marketing initiative:
- Initial Investment: $150,000
- Discount Rate: 10%
- Expected Cash Flows: $55,000/year for 4 years
Step 1 — Calculate NPV:
Year 1: $55,000 ÷ 1.10 = $50,000 Year 2: $55,000 ÷ 1.21 = $45,455 Year 3: $55,000 ÷ 1.331 = $41,323 Year 4: $55,000 ÷ 1.464 = $37,566 Total PV = $174,344 NPV = $174,344 − $150,000 = $24,344
Step 2 — Calculate PI:
PI = ($24,344 + $150,000) ÷ $150,000 = 1.162
Interpretation: The project generates $1.162 in present value for every $1 invested. Approve.
Pro Tips
- PI is most useful when capital budgets are constrained — it helps maximize value per dollar deployed.
- For a single isolated project decision, NPV and PI always give the same accept/reject signal.
- PI ignores the absolute dollar size of value created — a large project with PI = 1.05 may be better than a tiny one with PI = 1.50 if you have the capital.
- Always pair PI with a sensitivity analysis on the discount rate — if the rate changes by 2%, does the project still clear PI > 1?