Question

Suppose a company has proposed a new 5-year project. The project has an initial outlay of $212,000 and has expected cash flows of $40,000 in year 1, $41,000 in year 2, $53,000 in year 3, $61,000 in year 4, and $74,000 in year 5. The required rate of return is 16% 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= -$212,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 16%.
• Press enter after that. Press the down arrow and CPT buttons to get the net present value.

The present value of cash flows is -$44,170.59.

Profitability Index= -$44,170.59/ $212,000 = -0.21

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