Profitability Index Method
Profitability Index Method Formula
Profitability Index Calculation
Example: a company invested $20,000 for a project and expected NPV of that project is $5,000.
Profitability Index = (20,000 + 5,000) / 20,000 = 1.25
Profitability Index Example
Texabonds Inc has decided to consider a project where they predict the annual cash flows to be $5,000, $3,000 and $4,000, respectively for the next three years. At the beginning of the project, the initial investment put into the project is $10,000. Use the Profitability Index Method and a discount rate of 12% to determine if this is a good project to undertake. In order to solve this problem, it is probably a good idea to make a table so that the numbers can be organized by year.
Using a PI table, the following PVIF’s are found respectively for the 3 years: .893, .797, .712. Once the PVIF’s are determined, simply multiply the cash flows and the PVIF’s together in order to get the PV of cash flows for each respective year ($4,465, $2,391, $2,848). Adding up all the PV’s will get the total present value of the project which is $9,704. Divide that final number by the original investment $10,000 and the PI has been determined: .9704. As one can see, the Profitability Index is less than 1 so the project should be scrapped. The NPV can also be determined by subtracting the initial investment ($10,000) from the total PV of the project ($9,704) and you are left with -$296. In this case, because the number is negative, NPV also says that the project should be rejected.
Profitability Index Formula Table
A table for the problem is shown below:
YearCash FlowPVIF at 12%PV of Cash Flow 1$5,000.893$4,465 2 3,000.797 2,391 3 4,000.712 __2,848__
If you want to learn how to price profitably, then download the free Pricing for Profit Inspection Guide.
Access your Strategic Pricing Model Execution Plan in SCFO Lab. The step-by-step plan to set your prices to maximize profits.