Profitability Index Calculator
Enter the initial investment and the present value of future cash flows to find the profitability index, the NPV and whether the project adds value.
Updated
Profitability Index Calculator
Our Profitability Index Calculator shows how much value a project creates for every 1 invested. Enter the initial investment and the present value (PV) of the future cash flows, and it gives the profitability index (PI), the net present value and an accept or reject reading. It is made for investors, analysts, business owners and finance students who need to compare projects when capital is limited.
Quick answer
The profitability index is PV of future cash flows ÷ initial investment: 1,400,000 ÷ 1,000,000 = 1.4, so the project returns 1.40 of value for every 1.00 invested.
- PI above 1: the project adds value. Accept.
- PI equal to 1: the project breaks even.
- PI below 1: the project destroys value. Reject.
- Link to NPV: PI = 1 + NPV ÷ initial investment.
What Is the Profitability Index?
The profitability index (PI), also called the profit investment ratio (PIR) or value investment ratio (VIR), is a capital budgeting measure. It compares the present value of the cash a project is expected to bring in with the money it costs to start:
= PV of future cash flows
÷ Initial investment
- PV of future cash flows: the discounted value of all the cash inflows the investment is expected to generate.
- Initial investment: the total upfront cost needed to start the project.
The result is the present value earned per unit of investment, which helps investors and managers decide which projects are worth funding.
How to Interpret the Profitability Index
| PI | Decision |
|---|---|
| PI > 1 | Accept: the project adds value |
| PI = 1 | Neutral: the project breaks even |
| PI < 1 | Reject: the project destroys value |
The index is most useful when a business has limited capital and must choose between several projects. It answers how efficiently the capital is used and which project creates the most value per unit invested.
How to Calculate the Profitability Index
UrbanEco Developers, a real estate company, is weighing a sustainable housing project. The initial investment is 1,000,000 and the present value of the future cash flows is 1,400,000:
= 1.4
- Find the initial investment. The total upfront cost: 1,000,000.
- Find the PV of future cash flows. Discount every expected inflow to today: 1,400,000.
- Divide. 1,400,000 ÷ 1,000,000 = 1.4.
- Compare with 1. 1.4 is above 1, so the project adds value.
The project is expected to return 1.40 of present value for every 1.00 invested, a net present value of 400,000.
Finding the PV of Future Cash Flows
If you only have the yearly cash flows, discount each one before using the calculator. A cash flow received in year t is worth:
For example, a project costs 1,000 and pays 500 a year for three years. At a discount rate of 10%:
500 ÷ 1.10^2 ≈ 413.22
500 ÷ 1.10^3 ≈ 375.66
PV ≈ 1,243.43
PI ≈ 1,243.43 ÷ 1,000 ≈ 1.2434
Profitability Index Examples
| PV ÷ Investment | PI |
|---|---|
| Project A 260,000 ÷ 200,000 | 1.3 |
| Project B 195,000 ÷ 150,000 | 1.3 |
| Project X 85,000 ÷ 100,000 | 0.85 |
Projects A and B have the same index of 1.3. If the company can fund only one, other factors such as project scale, time horizon and strategic fit decide between them (A adds 60,000 of net present value, B adds 45,000).
Project X has an index of 0.85. Since that is below 1, the future cash flows are worth less than the investment and the project would lose 15,000 of value. The index lets decision makers reject it before committing funds.
Profitability Index vs NPV, IRR and Payback
| Metric | How PI differs |
|---|---|
| NPV | NPV is the total value created. PI is a ratio that measures efficiency, not total value. |
| IRR | IRR is the rate at which NPV is 0. PI focuses on value per unit invested. |
| Payback | Payback is the time to recover the cost. PI also counts the time value of money and the cash after payback. |
PI = 1 + NPV ÷ Initial investment
NPV tells you how much value is added and PI tells you how efficiently the capital is used, which makes PI well suited to ranking projects when funds are limited.
Where the Profitability Index Is Used
- Corporate finance. Evaluate projects, mergers or expansions.
- Startups. Analyse funding options and return potential.
- Investors. Compare several opportunities for capital efficiency.
- Teaching. Demonstrate capital budgeting concepts.
- Personal finance. Weigh up a property purchase or a business venture.
Limitations and Common Mistakes
- It relies on estimates. The index is only as good as the cash flow forecasts behind it.
- It ignores project size. For mutually exclusive projects of different sizes, a small project with a high PI can add less total value than a large one with a lower PI.
- It depends on the discount rate. A higher rate lowers the PV and the index.
- Entering undiscounted cash flows. The second field needs the present value, not the simple total of future cash flows.
- Counting the investment twice. Do not subtract the initial investment from the PV before dividing. That would give NPV ÷ investment, which is PI − 1.
For these reasons finance professionals usually read the profitability index alongside NPV and IRR.
Key Terms
- Profitability index
- PV of future cash flows ÷ initial investment.
- Present value
- What a future amount is worth today at a given discount rate.
- Initial investment
- The upfront cost of starting the project.
- NPV
- Net present value: PV of future cash flows minus the initial investment.
- Discount rate
- The yearly return required from the project, often the cost of capital.
- Capital rationing
- Choosing projects when the budget cannot fund them all.
How to Use the Profitability Index Calculator
- Enter the initial investment. Type the total upfront cost of the project, such as 1,000,000. Commas are fine.
- Enter the PV of future cash flows. Type the discounted value of all expected future cash inflows, such as 1,400,000.
- Read and copy the result. The profitability index appears as you type, with the working, the net present value and an Accept, Neutral or Reject reading. Press Copy to copy it, or Clear or Esc to start again.
Example: initial investment 200,000 and PV of future cash flows 260,000. The result is 1.3, from 260,000 ÷ 200,000 = 1.3, with a net present value of 60,000 and a decision of Accept.
Who Can Use This Calculator?
Frequently Asked Questions (FAQs)
How do you calculate the profitability index?
Divide the present value of the future cash flows by the initial investment. Profitability index = PV of future cash flows ÷ initial investment. A result above 1 means the project adds value.
What is the profitability index if the investment is 1,000,000 and the PV of future cash flows is 1,400,000?
It is 1.4. 1,400,000 ÷ 1,000,000 = 1.4, so the project returns 1.40 of present value for every 1.00 invested and has a net present value of 400,000.
What does a profitability index greater than 1 mean?
It means the present value of the future cash flows exceeds the initial investment, so the investment generates more value than it consumes. For example, a PI of 1.4 means every 1 invested returns 1.40 in present value.
What happens if the profitability index is less than 1?
The present value of the future cash flows is lower than the initial investment, so the project does not recover its cost and reduces the value of the firm. It should normally be rejected unless it has non-financial or strategic benefits.
How is the profitability index different from NPV?
NPV shows the absolute value created after subtracting the cost from the discounted cash inflows. PI shows how much value is generated per unit invested. The two are linked: PI = 1 + NPV ÷ initial investment.
Can the profitability index be used to rank projects?
Yes. When funds are limited, projects can be ranked from the highest PI to the lowest. When projects are mutually exclusive or differ a lot in size, use PI together with NPV or IRR.
Can the profitability index be negative?
Normally not. It is close to zero when the cash inflows are very small compared with the investment. A negative value would need a negative present value of future cash flows, meaning losses from the start, and this calculator does not accept a negative present value.
Is the Profitability Index Calculator free?
Yes. It is completely free, needs no sign-up, and can be used as many times as you like.
Sources
- OpenStax, Principles of Finance. 16.4 Alternative Methods.
- Corporate Finance Institute. Profitability Index.
- Wall Street Prep. Profitability Index (PI): Formula and Calculator.
- Wikipedia. Profitability index.
- Wikipedia. Net present value.
Try our Profitability Index Calculator to see whether a project adds value in seconds.