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=PV of Future Cash FlowsInitial InvestmentProfitability\ 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+NPVInitial InvestmentProfitability\ 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.

YearCash FlowDiscounted Cash Flows
0-5000.00
12000.001818.18
22,000.001652.89
32,000.001502.63
41,000.00683.01
51,000.00620.92

The total PV of future cash flows = 6277.64

Initial Investment = $5000

PI = 6277.64/5000 = 1.25

Since PI > 1, the project can be accepted.

The profitability index is a useful tool for capital rationing, as the projects can be ranked based on their PI.

Related Downloads

Related Quizzes

Capital Budgeting

Data Science in Finance: 9-Book Bundle

Data Science in Finance Book Bundle

Master R and Python for financial data science with our comprehensive bundle of 9 ebooks.

What's Included:

  • Getting Started with R
  • R Programming for Data Science
  • Data Visualization with R
  • Financial Time Series Analysis with R
  • Quantitative Trading Strategies with R
  • Derivatives with R
  • Credit Risk Modelling With R
  • Python for Data Science
  • Machine Learning in Finance using Python

Each book includes PDFs, explanations, instructions, data files, and R code for all examples.

Get the Bundle for $29 (Regular $57)
JOIN 30,000 DATA PROFESSIONALS

Free Guides - Getting Started with R and Python

Enter your name and email address below and we will email you the guides for R programming and Python.

Data Science in Finance: 9-Book Bundle

Data Science in Finance Book Bundle

Master R and Python for financial data science with our comprehensive bundle of 9 ebooks.

What's Included:

  • Getting Started with R
  • R Programming for Data Science
  • Data Visualization with R
  • Financial Time Series Analysis with R
  • Quantitative Trading Strategies with R
  • Derivatives with R
  • Credit Risk Modelling With R
  • Python for Data Science
  • Machine Learning in Finance using Python

Each book comes with PDFs, detailed explanations, step-by-step instructions, data files, and complete downloadable R code for all examples.