Profitability Index Calculator
Enter your initial investment and the present value of your expected future cash flows to get the Profitability Index instantly. Switch to multi-period mode to enter up to ten years of uneven cash flows: the calculator discounts each one at your chosen rate, sums them to PV, and then computes PI and NPV. A PI above 1.0 means the project creates value; below 1.0 it destroys it. The step-by-step panel shows every discounting calculation so you can audit the math.
Formula
Worked example
A project requires an initial investment of $100,000 and is expected to produce annual cash flows of $30,000, $30,000, $30,000, $25,000, and $20,000 over five years. At a 10% discount rate, the discounted cash flows are $27,273, $24,793, $22,539, $17,075, and $12,418, summing to a PV of $104,098. The PI is 104,098 / 100,000 = 1.041, and the NPV is $4,098. Because PI > 1, the project should be accepted.
What is the Profitability Index?
The Profitability Index (PI), also called the Value Investment Ratio or Profit Investment Ratio, is a capital budgeting metric that measures the amount of value created for each dollar of capital committed to a project. It is calculated as the present value of all future cash flows divided by the initial investment. A PI greater than 1.0 means the project earns more than its cost of capital and should be accepted; a PI below 1.0 means it destroys value and should be rejected. Because PI is a ratio rather than an absolute dollar amount, it is especially useful for ranking competing projects when capital is limited: the project with the highest PI squeezes the most value out of every dollar available.
How to use this calculator
If you already know the present value of the project's future cash flows, select "PV already known", enter the initial investment and the pre-computed PV, and the calculator returns PI, NPV, and a go/no-go decision immediately. If you only have raw annual cash flow estimates, switch to "Enter annual cash flows", set the number of years (up to ten), key in each year's expected net cash flow, and choose a discount rate that reflects your cost of capital or hurdle rate. The calculator discounts each cash flow back to today, sums them, and computes PI and NPV. The step-by-step panel shows every discounting operation, and the schedule table lists each period's cash flow, discount factor, discounted value, and running cumulative PV. The sensitivity chart (multi-period mode) plots PI against discount rates from 0 to 40% so you can see how robust the decision is at different costs of capital.
PI versus NPV: which metric to use?
Net Present Value and the Profitability Index are closely related - in fact PI = 1 + NPV / Initial Investment - but they answer slightly different questions. NPV tells you the absolute dollar amount of value a project creates or destroys. PI tells you the value created per dollar invested. When you can take any project with a positive NPV, NPV is the primary criterion because a large positive NPV beats a small one regardless of investment size. When capital is rationed and you must choose among more projects than you can fund, ranking by PI maximizes the total value you extract from a fixed budget. As a practical rule, always screen on NPV first (reject anything below zero) and then rank survivors by PI when resources are constrained.
Choosing the right discount rate
The discount rate should reflect the opportunity cost of the capital you are committing. For corporate projects this is typically the Weighted Average Cost of Capital (WACC), which blends the after-tax cost of debt and the cost of equity in proportion to the firm's capital structure. For projects with specific financing arrangements, the cost of that financing may be more appropriate. For personal or venture investments, a hurdle rate that reflects the return available from alternative opportunities of similar risk is common. A higher discount rate shrinks the PV of distant cash flows more aggressively, so long-duration projects are particularly sensitive to this choice. Use the sensitivity chart to see how the PI changes across a range of discount rates before committing.
Profitability Index interpretation
| PI range | Decision | What it means |
|---|---|---|
| PI < 1.0 | Reject | Discounted cash inflows are less than the initial cost - destroys value |
| PI = 1.0 | Break-even | Exactly recovers the cost in present-value terms - no net gain |
| 1.0 to 1.25 | Accept (marginal) | Creates modest value; worthwhile if no better alternative exists |
| 1.25 to 2.0 | Accept (good) | Solid value creation; typical for well-structured projects |
| PI > 2.0 | Accept (excellent) | Exceptional value creation; prioritize immediately |
Standard capital budgeting rules for the PI. When capital is constrained, rank projects by PI descending and fund from the top.
Frequently asked questions
What does a Profitability Index of 1.2 mean?
A PI of 1.2 means that for every dollar invested in the project, you receive $1.20 in present-value terms. Equivalently, the project generates $0.20 of net present value for each dollar of initial outlay. The project creates value and should be accepted (all else being equal). If you are choosing between two projects, the one with the higher PI is the better use of scarce capital.
Can the Profitability Index be negative?
The PI is negative only if the present value of future cash flows is negative, which would require the cash flows themselves to be predominantly negative (net outflows in future years). In most investment contexts the PI is positive but below 1.0 for loss-making projects. A PI below zero signals that the project incurs net costs in every discounted period, a very unusual situation.
What is a good Profitability Index?
Any PI above 1.0 is technically acceptable because it means the project earns more than the required return. In practice, most analysts consider a PI between 1.0 and 1.25 to be marginal, 1.25 to 2.0 to be good, and above 2.0 to be excellent. The right threshold depends on your industry, risk tolerance, and the quality of competing investment opportunities.
How is the Profitability Index different from ROI?
Return on Investment (ROI) is typically calculated as (gain - cost) / cost, using nominal (undiscounted) figures. The Profitability Index uses discounted present values, so it accounts for the time value of money and the risk-adjusted cost of capital. PI therefore gives a more accurate picture of value creation for multi-year projects, while ROI is simpler and widely used for quick comparisons.
Does a higher PI always mean a better project?
Not necessarily. PI is a ratio, so a small project with a PI of 2.0 may create far less total value than a large project with a PI of 1.3. Always check the absolute NPV alongside the PI. In capital rationing situations you rank by PI, but you still need to confirm that the shortlisted projects together do not leave large amounts of capital idle. Scale, strategic fit, and execution risk matter too.