Racira Calculator

Profitability Index Calculator

Profitability Index (PI) Calculator

$

Example: 120000,150000,180000 for 3 years

%
Profitability Index
1.271
Good Investment
NPV
$135,291
Total PV
$635,291
IRR
19.1%

Present Value by Year

Investment Summary

Initial Investment$500,000
Discount Rate10%
Number of Periods5 years
Total PV of Cash Flows$635,291
NPV$135,291
Profitability Index1.2706
IRR19.11%
Decision✓ Accept

What Is the Profitability Index?

The Profitability Index (PI), also known as the Profit Investment Ratio (PIR) or Value Investment Ratio (VIR), is a capital budgeting metric that measures the value created per unit of investment. It extends NPV analysis by providing a relative measure of investment efficiency — essential when comparing projects of different sizes or allocating limited capital across multiple opportunities.

Profitability Index Formula

PI = PV of Future Cash Flows ÷ Initial Investment

Where PV of Future Cash Flows = Σ (CFt ÷ (1+r)^t) for t = 1 to n. r = discount rate (WACC). CFt = cash flow in period t. Equivalently: PI = 1 + (NPV ÷ Initial Investment).

Interpreting the Profitability Index

PI = 1.0: The project earns exactly the required rate of return (zero economic profit). PI > 1.0: Accept — the project creates value above the cost of capital. PI < 1.0: Reject — the project destroys value. For capital rationing, rank all projects by PI and fund in descending order until the capital budget is exhausted. This maximizes total NPV across the portfolio.

PI vs. NPV — When Each Is Better

NPV is superior for independent projects where the absolute value creation matters. PI is superior for mutually exclusive projects of different sizes and for capital rationing scenarios. Example: Project A has NPV=$100K, investment=$500K (PI=1.20). Project B has NPV=$80K, investment=$200K (PI=1.40). With a $200K budget, Project B creates more value per dollar despite lower absolute NPV.

Discount Rate Selection

The discount rate represents the opportunity cost of capital — what your money could earn in a risk-equivalent alternative investment. Use WACC for projects aligned with the company's overall risk profile. Apply a risk premium (2–5%) for ventures more risky than typical operations. Use the risk-free rate plus equity risk premium for equity-financed projects without leverage.

PI in Capital Rationing

When a firm cannot fund all positive-NPV projects (due to budget constraints, credit limits, or strategic priorities), PI ranking enables optimal capital allocation. Sort available projects by PI in descending order. Fund from the top until the budget is exhausted. This algorithm maximizes total NPV across the funded portfolio — a fundamental result in corporate finance theory.

Limitations of the Profitability Index

PI assumes cash flows are known with certainty — use sensitivity analysis to stress-test key assumptions. It does not account for project interdependencies (e.g., two projects that share infrastructure). PI can be misleading for mutually exclusive projects of the same size — in that case, NPV provides the correct ranking. Always use PI alongside IRR and payback period for a complete capital investment evaluation.

Frequently Asked Questions

Related Calculators