What Is the Profitability Index PI?

formula for profitability index

Chartered accountant Michael Brown is the founder and CEO of Double Entry Bookkeeping. He has worked as an accountant and consultant for more than 25 years and has built financial models for all types of industries. He has been the CFO or controller of both small and medium sized companies and has run small businesses of his own. He has been a manager and an auditor with Deloitte, a big 4 accountancy firm, and holds a degree from Loughborough University. As the profitability index is a ratio, the scale of the project in absolute monetary terms is ignored.

The denominator consists of the total funds the firm initially needs to undertake the opportunity. It doesn’t matter the type of business that you operate or the industry that you are in. It also doesn’t matter if you’re a sole trader or a limited liability partnership. Generating profit and increasing that profit margin is the difference between keeping your doors open or closed. In this comprehensive exploration of the Profitability Index (PI), we’ve delved into the intricacies of evaluating investment opportunities. As we wrap up our discussion, let’s distill the key insights and takeaways from our journey.

In summary, the Profitability Index serves as a compass for navigating investment choices. By understanding its nuances and applying it judiciously, we empower ourselves to make informed decisions that balance financial gains with broader organizational goals. Remember, numbers alone don’t tell the whole story; context and judgment complete the narrative. The best I like about Profitability index is that it allows comparison among multiple investments of varying sizes and tenures in relative terms. It means that this investment will bring you a 56% return over the initial investment. Step 4) Hit Enter to have the present value of the given cash flows calculated.

  1. We found out all of the above-discounted cash flows by using the same method.
  2. Whether you’re a sole investor or a limited company, the ultimate goal should be to ensure that your investments — big or small — make financial sense.
  3. The expected future cash flows over the next five years are projected to be $25,000, $30,000, $35,000, $40,000, and $45,000, respectively.
  4. Also, it helps comparison by evaluating all big and small investments in terms of per unit of investment.

The profitability index can also get referred to as a profit investment ratio (PIR) or a value investment ratio (VIR). It represents the relationship that exists between the costs and the benefits of a potential project. The profitability index is the ratio between the initial amount invested in a project and the present value of future cash flows.

( . Project 1 and project 2 are both independent projects:

formula for profitability index

In order to help you advance your career, CFI has compiled many resources to assist you along the path. Download CFI’s Excel template to advance your finance knowledge and perform better financial analysis. Now that we have obtained the PI value for both the projects, let’s look into its application for appraising projects. However, both PIs are less than 1.0, so the company may forgo either project.

Sales & Investments Calculators

To calculate the PI, we need the estimated future cash flows to be generated from a project and the WACC for it. Profitability index is a profit investment ratio that helps evaluate the potential profitability of an investment. N Enterprise has decided to invest in a project for which the initial investment would be $100 million. As they are considering whether it’s a good deal to invest in, they have found out that the present value of the future cash flow of this project is 130 million. The profitability index helps compare and contrast investments and projects a company is considering. The PI is especially useful when a company has limited resources and can’t pursue all potential projects.

The profitability index helps rank projects because it lets investors quantify the value created per each investment unit. A profitability index of 1.0 is the lowest acceptable measure on the index. Mathematically, a value lower than one means the project’s present value (PV) is less than the initial investment. Anything lower than 1 indicates that the project’s present value is far less than the initial investment.

The Financial Modeling Certification

The best thing about this index is that it allows businesses to compare between different projects whenever they require choosing one out of the other. The projects having more chances of generating profits is the project that the firms are likely to choose. Profitability Index is a great metric to use when you need to decide whether you need to invest in something or not.

Cash Flow Statement

And lastly, investing in Catcher will earn Garch Ltd $155,000 in annual cash flow for the next 5 years. PI and Net Present Value (NPV) are two financial tools that are widely used as a profit estimation metric for businesses. PI and NPV are said to be directly proportional where positive NPV leads to PI that is greater than, while a negative NPV means a PI lower than 1. However, there is another way through which we can express PI, and that is through net present value. NPV method is a good measure as well to consider whether any investment is profitable or not. The numerator is the present value of cash flow that occurs after the initial funds have been invested into the project.

As every good side has its limitations, PI also has a couple of limitations. In the case of limited funds, we should rank projects according to profitability index (PI) ratios and not on the basis of their net present values (NPVs). Since project 2 and 3 both have higher PI values than project 1, they should be ranked ahead of project 1 while rationing the available capital. Suppose further that the company has only $40,000 available to invest and all the projects are independent, not mutually exclusive.

Because of cash constraint, It can’t undertake both project 1 and another from project 2 and 3. Rank the projects based on profitability and identify the projects that should be accepted keeping in view the company’s capital budget constraints. It can be helpful to calculate the net present value prior to calculating the profitability index. But, the profitability index can get calculated using the following profitability index formula(s). To best understand how to calculate and rank investment projects using the formula for profitability index profitability index equation, consider the following examples.

Scroll to Top