Question

Suppose a company has proposed a new 5-year project. The project has an initial outlay of $231,000 and has expected cash flows of $32,000 in year 1, $50,000 in year 2, $52,000 in year 3, $65,000 in year 4, and $72,000 in year 5. The required rate of return is 11% for projects at this company. What is the profitability index for this project? (Answer to the nearest hundredth, e.g. 1.23)

Answer 1

Profitability Index= PV of future cash flows/Initial investment

PV of future cash flows is calculated using a financial calculator by inputting the below:

• Press the CF button.
• CF0= -$231,000.
• Cash flow for each year should be entered.
• Press Enter and down arrow after inputting each cash flow.
• After entering the last cash flow cash flow, press the NPV button and enter the required rate of return of 11%.
• Press enter after that. Press the down arrow and CPT buttons to get the net present value.

The present value of cash flows is -$38,022.09

Profitability Index= -$38,022.09/ $231,000 = -0.16.

In case of any query, kindly comment on the solution.