📊 Profitability Index Calculator

The profitability index tells you how much present-value bang you get per dollar of investment. Divide the present value of all future cash flows by the upfront cost: a PI of 1.14 means every dollar invested comes back as $1.14 in today’s money. Above 1.0, accept. Below 1.0, reject. It is the ranking tool for choosing between projects when capital is limited.

PI and NPV always agree on accept or reject for a single project, but they rank competing projects differently. NPV picks the biggest pile of dollars. PI picks the most dollars per dollar invested, which is the right call when you cannot fund everything and must ration a fixed budget.

How to Use This Calculator

Enter the upfront investment, the expected cash flow per year, how many years the project runs, and your discount rate, usually your cost of capital or minimum required return. The calculator discounts the cash flows, divides by the investment, and gives the verdict.

The Profitability Index Formula

The bracketed term is the present value annuity factor, which converts a stream of equal yearly cash flows into one lump sum in today’s dollars at discount rate r. Multiply by the annual cash flow and you have what the future money is worth now. Divide by what you pay today and you get value per dollar invested.

The discount rate does the heavy lifting. It represents what your money could earn elsewhere, so a project must beat it to create value. Raise the rate and PI falls; that sensitivity is a feature. If a project only passes at an optimistic 6 percent but fails at 10, you have learned how thin its margin of safety is.

Worked Example

A bakery considers a $100,000 oven line expected to throw off $30,000 a year for 5 years. At a 10 percent discount rate, the annuity factor is [1 - 1.10^-5] / 0.10 = 3.7908. Present value = $30,000 x 3.7908 = $113,724. PI = $113,724 / $100,000 = 1.14. NPV = $13,724. Verdict: accept, since 1.14 clears 1.0.

Now suppose a second project needs $40,000, returns $14,000 a year for 5 years at the same rate. PV = $14,000 x 3.7908 = $53,071. PI = 1.33, NPV = $13,071. The first project has the bigger NPV, but the second has the higher PI. With only $100,000 to spend, the PI ranking wins: fund the 1.33 project first.

PI vs NPV: When Each One Wins

The classic trap is ranking mutually exclusive projects by PI alone. A $10,000 project with a PI of 2.0 creates $10,000 of value; a $1,000,000 project with a PI of 1.2 creates $200,000. If you can only pick one, NPV’s $200,000 beats PI’s 2.0. Use PI to ration a budget across independent projects, NPV to pick between alternatives.

What the Discount Rate Should Be

For most small businesses, the discount rate is the weighted cost of the money funding the project: loan interest after tax blended with the return owners expect on their equity. Using your loan rate alone understates risk because equity is not free. When in doubt, run the numbers at two rates, your best estimate and two points higher, and only proceed if the project passes both. Our present value calculator is handy for checking the discounting on uneven cash flows year by year.

Limits of the Index

PI assumes cash flows arrive evenly and can be reinvested at the discount rate, which flatters lumpy projects. It also says nothing about payback speed: a PI of 1.5 over 20 years ties money up far longer than the same PI over 4 years. Pair it with the payback period so you see both return per dollar and how long the dollars are gone. And remember the inputs are forecasts; a PI built on hopeful sales is precise arithmetic on a guess.

Capital Rationing: Where PI Earns Its Keep

Suppose the budget is $200,000 and three projects compete. Project A needs $120,000 with PI 1.10 (NPV $12,000). Project B needs $80,000 with PI 1.35 (NPV $28,000). Project C needs $100,000 with PI 1.25 (NPV $25,000). Ranking by NPV picks A first, which is wrong under a fixed budget. Ranking by PI picks B, then C: $180,000 spent, $53,000 of NPV, $20,000 left over. The PI ranking squeezes the most value from scarce capital, which is exactly the situation most businesses live in.

Two refinements keep the ranking honest. First, projects must be independent: if B and C are mutually exclusive alternatives for the same site, rank the pair by NPV and enter only the winner. Second, watch divisibility: PI assumes you can take projects whole, and leftover budget that cannot fund the next project is wasted unless smaller projects fill it. With those caveats handled, PI is the most practical ranking tool in capital budgeting, which is why textbooks teach it alongside NPV rather than beneath it.

PI With Uneven Cash Flows

Real projects rarely pay level annuities. A retail buildout might lose money in year one, break even in year two, then generate strongly. The PI formula handles this fine: discount each year’s cash flow individually and sum them, then divide by the investment. This calculator’s annuity shortcut is a starting point; for lumpy projections, run each year through a present value calculation and add them up. The accept rule does not change: above 1.0 creates value.

The deeper use of PI is comparing projects of different lives. A 3-year project with PI 1.3 and a 10-year project with PI 1.2 are not directly comparable, because the longer project ties capital up far longer for a thinner margin. Annualize the advantage or compare over a common horizon with reinvestment assumptions stated. And always pair PI with a payback check: a high PI over twenty years can still be the wrong call if the business needs its capital back sooner.

Estimates for planning only, not financial advice.