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

The Struggles of Private Company Accounting

Hiring the right accountant  When I meet a business owner operating at a successful $10 million in revenue, they often mention, “My CPA”… I immediately know that CEO/Entrepreneur is referring to their Tax CPA.  That is because one thing that all Entrepreneurs have in common is that they must file a tax return.  So, from

Read More »

IN CRISIS? GET A STRATEGIC CFO! – CEO Blindspots Podcast

Friend of the firm, Birgit Kamps, recently had Strategic CFO President, Dan Corredor, as a guest on her podcast, CEO Blindspots. CEO BLINDSPOTS HOST: Birgit Kamps. She was speaking five languages by the age of 10, and lived in five countries with her Dutch parents prior to becoming an American citizen. Birgit’s professional experience includes starting

Read More »

SHRM calls ICHRA the 401K for Group Health Benefits

Fed-up with group health insurance? ICHRA is the new way to offer great health benefits and avoid ACA penalties, SHRM calls it the 401K for group health benefits.  In 2020 the Department of Labor, HHS and IRS changed the rules for employer health benefits. They changed the Affordable Care Act mandates and penalties for every

Read More »

JOIN OUR NEXT SERIES

Financial Leadership Workshop

MARCH 28TH-31ST 2022

SHARE THIS ARTICLE

JOIN THE NEXT STRATEGIC CFO™ SERIES

Strategic CFO™ Financial Leadership Workshop
The Art of the CFO®

Days
Hours
Min
Sec

September 12-15th 2022