When money is limited, the question is not only if a project pays off but how much value it gives per dollar invested. This profitability index calculator takes the initial investment, the annual cash inflow, the number of years and the discount rate to give the present value of the inflows, the profitability index, the net present value and the simple payback.
How the calculation works
- Present value of the inflows = annual cash flow × (1 − (1 + r)^−n) ÷ r, where r is the discount rate and n the number of years.
- Profitability index PI = present value of the inflows ÷ initial investment. A PI above 1 means that the project returns more than it costs, in present-value terms.
- Net present value = present value of the inflows − initial investment. A PI above 1 matches a positive NPV.
- Simple payback = initial investment ÷ annual cash flow, the time to recover the outlay without discounting.
Example
A project costs $100,000 and brings $28,000 a year for 5 years, at a discount rate of 10%. The present value of the inflows is 28,000 × 3.7908 = $106,142. The profitability index is 106,142 ÷ 100,000 = 1.061, and the net present value is $6,142. The simple payback is 3.57 years.
Why it matters
Finance students, business owners and analysts use the index to compare projects of different sizes and to ration a budget. It gives a quick answer to the question of whether an investment returns more than it costs after the time value of money.
Good to know
The calculator assumes a single outlay at the start and an equal cash inflow at the end of each year, with no residual value, taxes or inflation changes. Real cash flows are uneven and uncertain, and the discount rate is a judgment. The index is one tool, and large decisions need a full model and professional advice. This is not investment advice.
Related tools
The net present value calculator gives the value in dollars, the IRR calculator finds the rate of return and the payback period calculator shows how long it takes to recover the cost.