Question: excel solution needed please excel formula the profitability index is...
Question details
EXCEL SOLUTION NEEDED PLEASE: EXCEL FORMULA
The profitability index is the present value of the future cash flows divided by the initial investment. If you remember, the NPV function really only calculates the present value of future cash flows, so we will use the NPV function divided by the initial investment to calculate the profitability index as follows:
Suppose we have a project with the following cash flows and required return. What is the profitability index of the project?
t | Cash flow |
0 | $ (30,000) |
1 | 8,000 |
2 | 10,000 |
3 | 11,000 |
4 | 17,000 |
5 | 12,000 |
Required return: | 12% |
PI: | |
Accept or reject: |