Profitability Index Calculator

Calculate the profitability index (PI) to evaluate investment opportunities. Determine if a project is worth pursuing based on the ratio of present value of future cash flows to the initial investment.

The total present value of all expected future cash flows
The upfront cost required for the project
The upfront cost (entered as positive number)
Required rate of return or cost of capital
%

Future Cash Flows by Year

Year 1
Year 2
Year 3
Year 4
Profitability Index (PI)
0.00
-

What is Profitability Index?

The Profitability Index (PI), also known as the Profit Investment Ratio (PIR) or Value Investment Ratio (VIR), is a capital budgeting tool used to evaluate the attractiveness of an investment or project. It measures the ratio between the present value of future expected cash flows and the initial investment.

The PI helps investors and companies rank projects when capital is limited, allowing them to identify which investments provide the best return per dollar invested.

Key Insight: A PI greater than 1.0 indicates a good investment - the present value of future benefits exceeds the initial cost. The higher the PI, the more attractive the investment.

PI Formula

Profitability Index = Present Value of Future Cash Flows / Initial Investment

Alternatively, using NPV:

PI = (NPV + Initial Investment) / Initial Investment = 1 + (NPV / Initial Investment)

Where the Present Value of Future Cash Flows is calculated as:

PV = CF1/(1+r)^1 + CF2/(1+r)^2 + ... + CFn/(1+r)^n

Where CF = Cash Flow, r = Discount Rate, n = Year

How to Interpret PI

PI ValueInterpretationDecision
PI > 1.0NPV is positive; project creates valueAccept
PI = 1.0NPV is zero; break-even pointIndifferent
PI < 1.0NPV is negative; project destroys valueReject

How to Calculate PI

  1. Identify the initial investment: Determine the upfront cost required for the project.
  2. Estimate future cash flows: Project the expected cash inflows for each period.
  3. Determine the discount rate: Use the required rate of return or cost of capital.
  4. Calculate present value: Discount each future cash flow to its present value.
  5. Sum the present values: Add up all discounted cash flows.
  6. Apply the formula: Divide total PV by initial investment.

Calculation Examples

Example 1: Simple PI Calculation

Given:

  • Initial Investment: $100,000
  • PV of Future Cash Flows: $125,000

Solution:

PI = $125,000 / $100,000 = 1.25

Decision: Accept (PI > 1.0 means $0.25 value created per $1 invested)

Example 2: With Cash Flow Discounting

Given:

  • Initial Investment: $50,000
  • Discount Rate: 8%
  • Year 1 CF: $15,000
  • Year 2 CF: $20,000
  • Year 3 CF: $25,000

Solution:

PV Year 1 = $15,000 / 1.08 = $13,889

PV Year 2 = $20,000 / 1.08^2 = $17,147

PV Year 3 = $25,000 / 1.08^3 = $19,845

Total PV = $50,881

PI = $50,881 / $50,000 = 1.018

Decision: Marginally acceptable

Advantages & Limitations

Advantages

Limitations

PI vs NPV

Both PI and NPV are related capital budgeting tools:

AspectProfitability IndexNet Present Value
TypeRatio (relative measure)Dollar amount (absolute measure)
ShowsReturn per dollar investedTotal value created
Best forRanking projects, capital rationingChoosing between projects
Accept ifPI > 1.0NPV > 0

Frequently Asked Questions

What discount rate should I use?

Use your company's weighted average cost of capital (WACC) or the required rate of return for similar-risk investments. This typically ranges from 8-15% for most businesses.

Can PI be negative?

No, PI cannot be negative since both the numerator (PV of cash flows) and denominator (initial investment) are positive. However, if future cash flows are negative, you'd need to reconsider the investment fundamentally.

Why might NPV and PI give different rankings?

This happens with mutually exclusive projects of different sizes. NPV shows total value, while PI shows efficiency. A smaller project might have higher PI but lower NPV than a larger project.

How is PI used in capital rationing?

When capital is limited, rank projects by PI and select from the top until the budget is exhausted. This maximizes value per dollar of constrained capital.