- 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.
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:
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 |
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
Data Science in Finance: 9-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)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.