Skip to content
FiftyCalc Free calculators for all 50 states

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

Sample figures

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.

Profitability Index Calculator

Initial investment, in dollars: enter 0 or more. Prefilled example: 100,000.

Cash flow per year (end of year), in dollars: enter a number. Prefilled example: 30,000.

Number of years: enter a number from 1 to 100. Prefilled example: 5.

Discount rate, in percent: enter a number from 0 to 100. Prefilled example: 8.

How to use this calculator

Fill in the fields in this order; each step takes you to its field.

  1. Initial investment, in dollars: enter 0 or more.
  2. Cash flow per year (end of year), in dollars: enter a number.
  3. Number of years: enter a number from 1 to 100.
  4. Discount rate, in percent: enter a number from 0 to 100.
  5. 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

  1. Pv={cf×yif r=0cf×(1−(1+r÷100)−y)r÷100otherwise
  2. Pi=Pvinv
Symbols used in the formula
SymbolMeaningUnit
invInitial investment$
cfCash flow per year (end of year)$
yNumber of years
rDiscount rate%
PvPresent value of the cash flows$
PiProfitability index

Worked example

Initial investment$100,000
Cash flow per year (end of year)$30,000
Number of years5
Discount rate8%
Present value of the cash flows$119,781
Net present value (NPV)$19,781
ReadingPI above 1: the project earns more than the discount rate
  1. Pv=30,000×(1−(1+8÷100)−5)8÷100=119,781.3
  2. Pi=119,781.3100,000=1.19781

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.

Related calculators