Profitability Index Calculator
Test cases replayed : 2 of 2 match · Methodology · No outside source listed
Calculate a project's profitability index (PI) and net present value from its investment, equal yearly cash flows and discount rate.
Result
Profitability index
Present value of the cash flows
- Net present value (NPV)
- Reading
Estimate for planning only, not tax, legal, financial or medical advice. This calculator uses the method explained on this page.
This browser did not allow copying. The sentence is in the box below, already selected: copy it with your keyboard or the menu.
How to use this calculator
Fill in the fields in this order; each step takes you to its field.
- Initial investment, in dollars: enter 0 or more.
- Cash flow per year (end of year), in dollars: enter a number.
- Number of years: enter a number from 1 to 100.
- Discount rate, in percent: enter a number from 0 to 100.
- Read the result: Profitability index; the panel also shows Present value of the cash flows, Net present value (NPV) and Reading.
How this calculator works
Profitability index = present value of future cash flows ÷ initial investment. With equal cash flows C for n years at discount rate r, the present value is C × (1 − (1 + r)^−n) ÷ r.
PI above 1 means positive NPV (NPV = present value − investment). PI is useful to rank projects when capital is limited, since it measures value created per dollar invested.
The formula
| Symbol | Meaning | Unit |
|---|---|---|
| Initial investment | $ | |
| Cash flow per year (end of year) | $ | |
| Number of years | ||
| Discount rate | % | |
| Present value of the cash flows | $ | |
| Profitability index |
Worked example
| Initial investment | $100,000 |
|---|---|
| Cash flow per year (end of year) | $30,000 |
| Number of years | 5 |
| Discount rate | 8% |
| Present value of the cash flows | $119,781 |
|---|---|
| Net present value (NPV) | $19,781 |
| Reading | PI above 1: the project earns more than the discount rate |
Profitability index 1.20
Each step uses the unrounded value of the step before it; figures on this page are rounded for display.
Frequently asked questions
What is the PI of $100,000 returning $30,000 a year for 5 years at 8%?
1.20: the cash flows are worth $119,781 today, an NPV of $19,781.
Can PI and NPV disagree?
When ranking projects of different sizes they can: a small project may have the higher PI while a large one has the higher NPV.