Profitability Index Calculator
Profitability Index (PI) Calculator
Example: 120000,150000,180000 for 3 years
Present Value by Year
Investment Summary
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
Home Loan Calculator
Calculate home loan EMI, total interest, and amortization schedule.
Auto Loan Calculator
Detailed auto loan with trade-in, taxes, fees, and amortization.
Bike Loan Calculator
Calculate bike loan EMI, total cost, and repayment breakdown.
Boat Loan Calculator
Estimate boat financing payments, interest, and amortization.
Student Loan Calculator
Calculate student loan payments with income-driven repayment plans.
Gold Loan Calculator
Calculate gold loan amount based on gold weight, purity, and LTV ratio.
USDA Loan Calculator
Calculate USDA loan payments with guarantee fee and income eligibility.
Loan Against Property Calculator
Calculate LAP EMI based on property value and loan-to-value ratio.