Skip to content
UseCalcNow
Finance

Profitability Index Calculator — Rank Capital Projects

Compute the profitability index (PI) from projected cash flows and your discount rate. Rank competing projects and screen out investments with PI below 1.

About This Calculator

The profitability index (PI) compares the present value of a project's future cash flows against the money you put in up front. Divide one by the other and you get the dollars of present value created per dollar invested. This calculator discounts up to five years of projected cash flows at your chosen rate, then reports the PI along with the year-by-year present values. A PI of 1.0 is the break-even line for value creation; anything below it means the project returns less than it costs in today's money.

The Formula Behind This Calculator

PI = PV of future cash flows ÷ initial investment. Each year's cash flow is discounted by (1 + r)^t, where r is the discount rate entered as a percentage and t is the year number. The calculator discounts every year with a non-zero entry, sums the results, and divides that present value by the initial investment. For example, with a $100,000 outlay and cash flows discounting to $118,700 in total, the PI is 1.187 — the project returns $1.187 in present value per dollar invested.

Understanding the math helps you verify results and make better decisions for your project.

How to Use

  1. 1Enter the initial investment — the full up-front outlay including installation, working capital, and any shipping or setup costs.
  2. 2Type your expected net cash inflow for each of the five years. Leave a year at 0 if the project ends early or a year generates no cash.
  3. 3Set the discount rate to your company's hurdle rate, usually its weighted average cost of capital plus a risk premium.
  4. 4Read the PI result. Values at or above 1.0 create value; values below 1.0 destroy it.
  5. 5Use the year-by-year present value breakdown to see which years carry the project's value.

When to Use

  • →Comparing several projects when the capital budget cannot fund them all.
  • →Screening proposals before running a full net present value workup.
  • →Deciding whether to greenlight a single investment with a known hurdle rate.
  • →Checking that earlier payback or IRR figures hold up once discounting is applied.

Tips

  • ✓Exclude sunk costs from the initial investment — only cash outlays that change with the decision belong in the denominator.
  • ✓Include working capital and salvage value in the cash flow years where they actually occur.
  • ✓Match the discount rate to the project's risk, not to the company's cheapest funding source.
  • ✓Under capital rationing, rank projects by PI rather than absolute NPV to squeeze the most value from a fixed budget.
  • ✓Re-run the calculation with a higher discount rate to stress-test projects with back-loaded cash flows.

What the Profitability Index Actually Measures

The profitability index answers one question: how many dollars of present value do you get back for every dollar you invest today? The ratio divides the discounted value of all future cash flows by the up-front outlay. A PI of 1.40 means each invested dollar buys $1.40 of present value, so the project clears its cost of capital by 40 cents on the dollar. The 1.0 line marks the exact point where value creation begins — below it, the project returns less than the money tied up in it.

Because the index is a ratio, it normalizes projects of very different sizes. That is what makes it useful next to a net present value calculator, which measures absolute dollars instead. A warehouse automation project with a $2.4 million NPV on a $30 million outlay has a PI of 1.08, while a $400,000 fleet upgrade with a $180,000 NPV reaches 1.45. Both deserve funding when money is plentiful; only the second survives a tight budget round.

The Formula Behind the Result

PI = Σ [CFt ÷ (1 + r)^t] ÷ initial investment. Every future cash flow CFt gets divided by (1 + r)^t, where r is the periodic discount rate and t runs from 1 to the final year. The calculator applies this to each of the five cash-flow fields you fill and sums the discounted amounts. That sum is the present value of the project's stream, and dividing it by the initial investment produces the index.

The discount rate you enter does the heavy lifting. Deriving it with a discount rate calculator ties the analysis to your actual financing mix instead of a guess. At 8% the same cash flows can produce a healthy PI of 1.3, while at 14% the same project can drop below 1.0 and lose its funding. Small rate changes move long-duration projects hard because the discount factor compounds every year.

How PI Stacks Up Against NPV, IRR, and Payback

Every capital budgeting metric frames value differently. An internal rate of return calculator finds the rate where NPV hits zero, which reads intuitively but distorts results for projects with unusual cash-flow patterns. PI keeps the discount rate external and fixed, so comparisons across projects stay honest. For teams committed to IRR-style thinking, a modified IRR calculator fixes the reinvestment-rate assumption that plagues the plain version.

Payback measures liquidity, not value. A payback period calculator tells you when your cash comes back but ignores everything after that date and skips discounting altogether. PI captures the full life of the project in present-value terms. In practice, finance teams run payback for risk screening and PI or NPV for the actual accept-reject decision.

Decision Rules: Reading Your PI Result

The textbook rule reads: accept when PI is at least 1, reject when PI sits below 1. A PI of exactly 1.0 means the project earns precisely its discount rate — it neither creates nor destroys value. Companies often add margin above the threshold. A common house rule treats 1.0 to 1.1 as indifferent, 1.1 to 1.3 as acceptable, and anything above 1.3 as attractive, though the bands depend on industry volatility and forecast confidence. Bank loan committees often ask for the PI alongside the NPV because the ratio shows how much cushion the project carries over its financing cost.

The threshold logic ties directly to your financing costs. If your discount rate comes from a cost of capital calculator that reports 11%, then a PI above 1.0 means the project beats that 11% hurdle after adjusting for timing. Projects hovering near 1.0 with back-loaded cash flows deserve extra scrutiny, because the far-out cash flows carrying the value are the least certain ones in the forecast.

Ranking Competing Projects Under Capital Rationing

Capital rationing is the reality at most firms: more good projects than money. When you can only fund a subset, rank by PI rather than NPV. Funding in descending PI order packs the most present value into the fixed budget, because every dollar committed buys the highest available return in present-value terms. NPV ranking can waste the entire budget on one huge project while leaving several higher-yield small ones unfunded.

A worked example makes the point. Suppose you have $500,000 to deploy. Project A needs $480,000 with a PI of 1.15; projects B, C, and D each need $150,000 with PIs of 1.9, 1.6, and 1.4. Choosing A alone creates $72,000 of NPV, while funding B, C, and D costs $450,000 and creates $585,000. The PI-ranked portfolio wins by a wide margin and still leaves $50,000 free. Drafting each project's cash flows in a DCF calculator first makes this ranking exercise fast.

Common Mistakes That Skew the Index

The most frequent error is skipping the discounting entirely — dividing the raw sum of cash flows by the investment. A five-year project with $130,000 of undiscounted inflows on a $100,000 outlay looks like a sure winner at 1.30, but discount those same flows at 10% and the PI falls to roughly 0.99, meaning the project quietly destroys value. The second mistake is inconsistent rates: discounting labor savings at 6% while charging equipment flows 12% produces an index nobody should trust. A third slip happens when teams net salvage value out of the initial investment instead of discounting it in its final year — the timing difference matters and the index drifts off the true figure.

Two more traps hide in the inputs. Leaving incremental working capital out of the outlay shrinks the denominator and flatters the PI. Mixing in sunk costs — money already spent regardless of the decision — pushes the index down unfairly. For steady yearly inflows, the annuity math inside an annuity present value calculator gives a fast sanity check on your discounted total before you trust the index.

Where PI Fits in a Real Approval Workflow

In most corporate finance processes, PI sits in the screening stage. Proposals arrive with forecasts, an analyst discounts them at the company hurdle rate, and the PI sorts the pile before detailed due diligence starts. A quick ROI calculator pass often happens first to eliminate non-starters; PI then handles the ranking of what remains. Only shortlisted projects get the full modeling treatment with sensitivity analysis and scenario runs.

Small businesses can run the same sequence without the formality. A shop owner weighing a $60,000 pizza oven against a $25,000 delivery van upgrade can discount each option's expected cash flows, compare the two PIs, and commit the money where the index is highest. The logic mirrors a break even calculator for unit sales — except here the threshold is dollars of present value per dollar spent, not units sold before covering fixed costs.

Limits of the Ratio: When PI Misleads

PI is scale-blind by design. A $1,000 project with a PI of 2.5 adds $1,500 of value, while a $900,000 project with a PI of 1.2 adds $180,000. Ranking by PI alone would pick the small one and leave the larger wealth creation on the table. When projects are mutually exclusive — build one factory in Texas or one in Ohio, never both — the decision belongs to absolute NPV, with PI in a supporting role for phasing and timing. Firms handling dozens of proposals each quarter also pair PI with portfolio limits per division, which keeps one department from soaking up the full budget.

The index also inherits every weakness of its inputs. Forecast cash flows are estimates, and the discount rate is a judgment call. Back-loaded projects with attractive PIs can flip below 1.0 after a two-point rate increase, so run the numbers at two or three rates before committing. Used with honest forecasts and a sensible rate, the profitability index remains one of the cleanest tools for deciding where the next dollar goes.

FAQ

What is a good profitability index?

Anything above 1.0 adds value in present value terms. Most companies want real headroom, though — a PI between 1.0 and 1.1 leaves little margin for forecasting error, so many teams set an informal floor of 1.2 for risky projects.

How is the profitability index different from NPV?

NPV reports dollars of value created; PI reports value per dollar invested. A $5 million project and a $500,000 project can both be worth doing, but the smaller one may carry the higher PI. NPV decides absolute wealth creation, PI decides ranking under a fixed budget.

Can a project have a positive NPV but a PI below 1?

No. NPV equals the present value of cash flows minus the initial investment, so a positive NPV means the discounted cash flows exceed the outlay and the PI must sit above 1.0. The two rules always agree on a single project; they can disagree when ranking several projects against each other.

What discount rate should I use?

Most firms use their weighted average cost of capital as a floor and add a premium for project-specific risk. If you lack a WACC figure, the expected return on your next-best alternative investment is a defensible proxy.

Does the profitability index work with uneven cash flows?

Yes. Each year is discounted separately, so lumpy patterns like a major overhaul in year 3 or a salvage payment in year 5 are handled exactly. Enter the net figure for each year, with negative numbers for cash out years.

Why is PI preferred under capital rationing?

When the budget is fixed, choosing by highest PI maximizes total NPV per dollar committed. Picking by raw NPV can consume the whole budget on one large project while skipping several smaller ones that together create more value.

Related Calculators