Table of Contents
What is Profitability Index Formula?
The formula for Profitability Index is simple and it is calculated by dividing the present value of all the future cash flows of the project by the initial investment in the project.
It can be represented as
It can be further expanded as below,
Profitability Index Formula = PV of future cash flows / Initial investment
 Profitability Index = (Net Present value + Initial investment) / Initial investment
 Profitability Index Formula = 1 + (Net Present value / Initial investment)
Explanation of the Profitability Index Formula
The formula for the Profitability Index can be calculated by using the following steps:
Step #1: Firstly, the initial investment in a project has to be assessed based on the project requirement in terms of capital expenditure for machinery & equipment and other expenses which are also capital in nature.
Step #2: Now, all the future cash flows expected from the project are required to be determined. Then the discounting factor has to be calculated based on the current expected return from an investment of similar risk. Now, using the discounting factor, the present value of the future cash flows from the project can be calculated.
Step #3: Finally, the profitability index of the project is calculated by dividing the present value of all the future value of cash flow from the project (step 2) by the initial investment in the project (step 1).
Profitability Index Formula = PV of future cash flows / Initial investment
Example of Profitability Index Calculation (with Excel Template)
Let us see some simple to advanced examples of Profitability Index Formula to understand it better.
Profitability Index Excel Calculation Example #1
Let us take the example of company ABC Ltd which has decided to invest in a project where they estimate the following annual cash flows:
 $5,000 in Year 1
 $3,000 in Year 2
 $4,000 in Year 3
At the beginning of the project, the initial investment required for the project is $10,000 and the discounting rate is 10%.
PV of cash flow in Year 1= $5,000 / (1+10%)^{1} = $4,545
PV of cash flow in Year 2 = $3,000 / (1+10%)^{2} = $2,479
PV of cash flow in Year 3 = $4,000 / (1+10%)^{3} = $3,005
So, Sum of PV of future cash flows will be:
Profitability Index of the project = $10,030 / $10,000
As per the formula of profitability index, it can be seen that the project will create the additional value of $1.003 for every $1 invested in the project. Therefore, the project is worth investing since the it is more than 1.00.
Profitability Index Excel Calculation Example #2
Let us take the example of a company A which is considering two projects:
Project A
Project A needs an initial investment of $2,000,000 and a discount rate of 10% and with estimated annual cash flows of:
 $300,000 in Year 1
 $600,000 in Year 2
 $900,000 in Year 3
 $700,000 in Year 4
 $600,000 in Year 5
Initial investment = $2,000,000
PV of cash flow in Year 1= $300,000 / (1+10%)^{1} = $272,727
PV of cash flow in Year 2 = $600,000 / (1+10%)^{2} = $495,868
PV of cash flow in Year 3 = $900,000 / (1+10%)^{3} =$676,183
PV of cash flow in Year 4 = $700,000 / (1+10%)^{4} = $478,109
PV of cash flow in Year 5 = $600,000 / (1+10%)^{5} =$372,553
So, Sum of PV of future cash flows will be:
Profitability Index of Project A = $2,295,441 / $2,000,00
Project B
The initial investment of $3,000,000 and discount rate of 12% and with estimated annual cash flows of:
 $600,000 in Year 1
 $800,000 in Year 2
 $900,000 in Year 3
 $1,000,000 in Year 4
 $1,200,000 in Year 5
PV of cash flow in Year 1= $600,000 / (1+12%)^{1} = $535,714
PV of cash flow in Year 2 = $800,000 / (1+12%)^{2} =$637,755
PV of cash flow in Year 3 = $900,000 / (1+12%)^{3} =$640,602
PV of cash flow in Year 4 = $1,000,000 / (1+12%)^{4} =$635,518
PV of cash flow in Year 5 = $1,200,000 / (1+12%)^{5} =$680,912
So, Sum of PV of future cash flows will be:
Profitability Index of Project B = $3,130,502 / $3,000,000
Using the formula of profitability index, it can be seen that Project A will create the additional value of $0.15 for every $1 invested in the project compared to Project B which will create an additional value of $0.04 for every $1 invested in the project. Therefore, Company A should select Project A over Project B.
Profitability Index Formula Calculator
You can use the following Profitability Index Formula calculator
PV of Future Cash Flows  
Initial Investment  
Profitability Index Formula =  
Profitability Index Formula = 


Relevance and Use of Profitability Index Formula
The concept of profitability index formula is very important from the point of view of project finance. It is a handy tool to use when one needs to decide whether to invest in a project or not. The index can be used for ranking project investment in terms of value created per unit of investment.
 The basic idea is that – higher the index, the more attractive the investment.
 If the index is greater than equal to unity, then the project adds value to the company or otherwise, it destroys value when the index is less than unity.
You can download this Profitability Index Formula Excel Template from here – Profitability Index Formula Excel Template
Recommended Articles
This has been a guide to Profitability Index Formula. Here we discuss how to calculate the Profitability Index in excel along with practical examples and downloadable excel template. You can learn more about excel modeling from the following articles –
Leave a Reply