Profitability Index Method Formula

Profitability Index Method Formula

See Also:
Profitability Index Method

Profitability Index Method Formula

Use the following formula where PV = the present value of the future cash flows in question.
Profitability Index = (PV of future cash flows) ÷ Initial investment
Or = (NPV + Initial investment) ÷ Initial Investment: As one would expect, the NPV stands for the Net Present Value of the initial investment.

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
That means a company should perform the investment project because profitability index is greater than 1.

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:

Year			Cash Flow		PVIF 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.
Profitability Index Method Formula
[box]Strategic CFO Lab Member Extra
Access your Strategic Pricing Model Execution Plan in SCFO Lab. The step-by-step plan to set your prices to maximize profits.

Click here to access your Execution Plan. Not a Lab Member?
Click here to learn more about SCFO Labs[/box]

Profitability Index Method Formula

ARTICLES YOU MIGHT LIKE

Financial Ratios

See also: Quick Ratio Analysis Price to Book Value Analysis Price Earnings Growth Ratio Analysis Time Interest Earned Ratio Analysis Use of Financial Ratios Financial Ratios are used to measure financial performance against standards. Analysts compare financial ratios to industry averages (benchmarking), industry standards or rules of thumbs and against internal trends (trends analysis). The

Read More »

Margin vs Markup

See Also: Gross Profit Margin Analysis Retail Markup Chart of Accounts (COA) Margin Percentage Calculation Markup Percentage Calculation Margin vs Markup Differences Is there a difference between margin vs markup? Absolutely. More and more in today’s environment, these two terms are being used interchangeably to mean gross margin, but that misunderstanding may be the menace

Read More »

Markup Percentage Calculation

See Also: Margin vs Markup Margin Percentage Calculation Retail Markup Gross Profit Margin Ratio Analysis Operating Profit Margin Ratio Analysis Markup Percentage Definition Define the markup percentage as the increase on the cost price. The markup sales are expressed as a percentage increase as to try and ensure that a company can receive the proper

Read More »

JOIN OUR NEXT SERIES

Financial Leadership Workshop

MARCH 28TH-31ST 2022

THE ART OF THE CFO®

Financial Leadership Workshop

Days
Hours
Min

September 12-15th 2022

Days
Hours
Min
SHARE THIS ARTICLE

JOIN THE NEXT STRATEGIC CFO™ WORKSHOP SERIES

Strategic CFO™ Financial Leadership Workshop
The Art Of The CFO®

Days
Hours
Min

December 5-8th, 2022