1. Business
  2. Finance
  3. excel solution needed please excel formula the profitability index is...

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:
Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution