- Calculating Net Present Value (NPV) and Internal Rate of Return (IRR) in Excel
- Net Present Value of a Project
- The Capital Budgeting Process
- Principles of Capital Budgeting
- Mutually Exclusive Projects, Project Sequencing, and Capital Rationing
- How to Calculate Payback Period
- How to Calculate Discounted Payback Period
- Calculating Profitability Index of a Project
- Conflict Between NPV and IRR

# Calculating Profitability Index of a Project

The profitability index, also known as the profit investment ratio, is calculated as the ratio of the present value of the future cash flows and the initial investment in the project.

$Profitability\ Index = \frac{PV\ of\ Future\ Cash\ Flows}{Initial\ Investment}$

Since NPV is the difference between the present value of future cash flows and initial investment, the profitability index can also be expressed in terms of NPV as follows:

$Profitability\ Index = 1 + \frac{NPV}{Initial\ Investment}$

The firms use PI to decide whether to accept or reject a project.

PI > 1, Accept the project

PI < 1, Reject the project

Let's taken an example to understand how profitability index is calculated. Assume that a company invests $5,000 in a project, which generates the following cash flow in the next 5 years. The firm has a cost of capital of 10%. Column 3 presents the discounted cash flows.

Year | Cash Flow | Discounted Cash Flows |

0 | -5000.00 | |

1 | 2000.00 | 1818.18 |

2 | 2,000.00 | 1652.89 |

3 | 2,000.00 | 1502.63 |

4 | 1,000.00 | 683.01 |

5 | 1,000.00 | 620.92 |

# This content is for paid members only.

Join our membership for lifelong unlimited access to all our data science learning content and resources.