Profitability Index Calculator

Two steps to find out if your project is worth pursuing — enter your investment, cash flows, and discount rate to calculate the Profitability Index and Net Present Value instantly.

By CalcMastery Editorial Team

Profitability Index Calculator

Compute Profitability Index (PI) from an initial investment, a discount rate, and either fixed or varying cash flows by year.

$

Upfront outlay at time 0 (enter a positive number).

Fixed Each YearVarying by Year
%

Annual discount rate in percent (e.g., 10 for 10%).

Analysis horizon in years.

$

Expected equal cash inflow received at the end of each year.

Year
Amount

Enter inflows (+) and outflows (-) by year index starting at 1.

Results

  • Profitability Index (PI)
  • Decision
  • PV of Inflows$
  • Initial Investment$
  • Net Present Value (NPV)$

Enter your inputs above to calculate the results.

Formula

PI = PV of Future Cash Inflows / Initial Investment

Meaning:

  • PI = Profitability Index
  • PV of Future Cash Inflows = Present value of all expected future cash flows
  • Initial Investment = The total amount of money invested at the start

Example:

A project costs $10,000 and generates $3,000 per year for 5 years, with a 10% discount rate.

Step 1: Calculate PV of inflows

PV = 3000 × (1 − (1 + 0.10)-5) / 0.10 = 3000 × 3.7908 = 11,372.36

Step 2: Apply the PI formula

PI = 11,372.36 / 10,000 = 1.137

Result:

Since PI > 1, the project is profitable and should be accepted.

How to Use the Profitability Index Calculator

Enter Initial Investment

The total amount you plan to invest (e.g., 10,000).

Select Cash Flow Mode

Choose Fixed Each Year if yearly cash inflows are the same, or Varying by Year if they differ.

Input Discount Rate (%)

The annual required rate of return (e.g., 10%).

Enter Number of Years

How long the project will generate cash flows (e.g., 5).

Enter Cash Flow per Year

The expected annual inflow (e.g., 3,000).

Click Calculate to see results:

    • Profitability Index (PI): PV of inflows ÷ initial investment

- NPV: PV of inflows − initial investment - Decision: Accept if PI > 1, Reject if PI < 1 Example: For a $10,000 investment, 10% discount rate, 5 years, and $3,000 cash flow per year → PI = 1.137, Decision: Accept.

Frequently Asked Questions

When should I use a Profitability Index Calculator in my capital-budgeting process?

Use it when you need to decide whether to go ahead with a project and especially when you’re comparing multiple investment options under a limited budget. It gives you a clear ratio of value created per dollar invested.

What sort of cash-flow scenarios make the Profitability Index metric less reliable on its own?

If the project has massive up-front investment but low relative returns, or if cash-flows are highly uncertain, the PI may look acceptable (>1) but still mask risk or poor absolute yield. Also, PI doesn’t account for project size fully — a small high-PI project might generate less value than a large lower-PI one.

Can the Profitability Index Calculator be used for personal or small-business investments, not just corporate projects?

Yes—though originally a corporate tool, you can apply it to any investment requiring an initial outlay and future returns. Just ensure you discount future cash-flows properly (adjusting for risk/time) and compare to what the initial investment is.

How do assumptions around the discount rate and cash-flow estimation affect the output of the Profitability Index Calculator?

They affect it drastically. If you set an overly optimistic discount rate (too low) or over-estimate future cash invites, you’ll overstate the PI. Conversely, pessimistic estimates reduce PI. It’s only as accurate as those inputs, so you should stress-test assumptions before relying on the PI.

Once I get a PI value from the calculator, what’s the practical decision rule and next-steps?

If PI > 1 → the project creates value and is generally acceptable. If PI = 1 → it breaks even, so only pursue if strategic reasons justify it. If PI < 1 → value is destroyed, likely reject. After that, compare to other metrics (like NPV or IRR) and consider project constraints, risk, and size to make the final call

Sources & Methodology