Profitability Index Calculator
Calculate profitability index (PI) and NPV from initial investment, discount rate, and cash flows.
Use the Profitability Index Calculator
Enter initial investment, discount rate, and cash flows by year. PI and NPV are calculated.
Investment & cash flows
Initial investment (outflow), discount rate, and future cash inflows by year.
Results
PI = NPV of inflows ÷ Initial investment. PI > 1 suggests value creation (NPV > 0). Accept/reject: PI > 1 = accept.
What this metric means
Profitability index measures value created per dollar of investment. It's NPV scaled by initial outlay, useful for ranking projects of different size.
How to calculate it
NPV of inflows = Σ CF_t ÷ (1 + r)^t. PI = NPV of inflows ÷ Initial investment. NPV = NPV of inflows − Initial investment.
How to improve the metric
Increase cash inflows or bring them forward; reduce initial investment; or lower the discount rate if it's appropriate (e.g. lower risk).
Common mistakes
Using undiscounted cash flows; mixing pre- and after-tax; or including financing flows in the investment or cash flows.
How to interpret your result
PI > 1: accept (value-creating). PI < 1: reject. Use with NPV for magnitude of value and with other projects when capital is constrained.
FAQs
What is the profitability index?▾
How is it different from NPV?▾
What discount rate should I use?▾
Accept or reject?▾
Related tools
Browse all calculators on NetGrow.