Profitability Index Calculator

Calculate the profitability index (PI) to evaluate investment projects and compare their relative profitability. Enter your initial investment and expected cash flows to determine if a project creates value.

Updated June 2026 · How this works

Initial Investment

Discount Rate (%)

Year 1 Cash Flow

Year 2 Cash Flow

Year 3 Cash Flow

Year 4 Cash Flow

Year 5 Cash Flow

—

See a way to make this better?

Learn more

How It Works

The formula, explained simply

The profitability index calculator helps investors and business managers evaluate whether capital projects create or destroy value. This financial metric compares the present value of expected future cash flows to the initial investment required, providing a ratio that indicates value creation potential.

To calculate the profitability index, the tool first converts your discount rate into a decimal and applies it to discount each year's expected cash flow back to present value. Each cash flow is divided by (1 + discount rate) raised to the power of the year number. For example, year 2 cash flows are divided by (1 + rate)². The calculator sums all discounted cash flows to determine total present value.

The final step divides the total present value by your initial investment to produce the profitability index ratio. A PI greater than 1.0 indicates value creation, exactly 1.0 represents break-even, and less than 1.0 suggests value destruction. This ratio allows direct comparison between projects of different sizes and time horizons.

The profitability index calculator is particularly useful when evaluating multiple competing projects with limited capital. Unlike net present value, which shows absolute dollar value creation, PI reveals relative efficiency of capital deployment, helping prioritize projects that generate the most value per dollar invested.

When To Use This

Right tool, right situation

Use the profitability index calculator when comparing multiple investment projects, especially when capital is limited and you must choose between competing opportunities. It's particularly valuable for capital budgeting decisions, equipment purchases, research and development investments, and expansion projects. The PI is most useful when projects have different initial investment amounts, as it shows value creation per dollar invested. However, supplement PI analysis with other metrics like NPV and IRR for comprehensive project evaluation.

Common Mistakes

Why results sometimes look wrong

Common mistakes include using nominal cash flows with real discount rates (or vice versa), failing to include all relevant cash flows like working capital changes or salvage value, and ignoring the time value of money by not properly discounting future cash flows. Many users also mistake accounting profits for cash flows - use actual cash receipts and payments, not book profits. Another frequent error is applying the wrong discount rate; use your weighted average cost of capital or project-specific risk-adjusted rate, not arbitrary percentages.

∑

The Math

Worked examples and deeper derivation

The profitability index formula is: PI = PV of Future Cash Flows ÷ Initial Investment. The present value calculation uses the standard discounting formula: PV = CF ÷ (1 + r)^n, where CF is the cash flow, r is the discount rate, and n is the year number. For multiple years, sum each discounted cash flow: PV = CF₁/(1+r)¹ + CF₂/(1+r)² + CF₃/(1+r)³ + ... The discount rate should reflect your cost of capital or minimum acceptable return, typically between 8-15% for most businesses.

Software Development Project

$150,000 initial investment, 12% discount rate, cash flows of $50,000, $60,000, and $70,000 over three years

The profitability index of 1.083 shows this project creates value and should be accepted.

Manufacturing Equipment Purchase

$200,000 initial cost, 15% required return, annual cash flows of $45,000 for five years

With a PI of 0.754, this equipment purchase destroys value and should be rejected.

Marketing Campaign Investment

$75,000 upfront cost, 10% discount rate, expected returns of $35,000 in year 1 and $50,000 in year 2

The PI of 1.060 indicates modest value creation, making this campaign marginally acceptable.

Common questions

How do you calculate profitability index for investment decisions?

Calculate profitability index by dividing the present value of future cash flows by the initial investment. First, discount each year's expected cash flow back to present value using your required rate of return, then sum these present values and divide by the upfront investment cost. A PI greater than 1.0 indicates the project creates value.

What does a profitability index of 1.2 mean?

A profitability index of 1.2 means the project creates significant value. For every dollar invested, you receive $1.20 in present value back. This represents a 20% value premium above your minimum required return, making it an attractive investment opportunity that should typically be accepted.

Should I accept projects with profitability index less than 1?

Generally no, projects with PI less than 1.0 should be rejected because they destroy shareholder value. These projects fail to generate returns that meet your minimum required rate of return. However, consider strategic benefits, market positioning, or regulatory requirements that might justify accepting marginally unprofitable projects in specific circumstances.

Need something this doesn't cover?

Suggest a tool — we'll build it →