To calculate the NPV (Net Present Value), IRR (Internal Rate of Return), MIRR (Modified Internal Rate of Return), profitability index, and payback for the given projects, we will use the provided cash flows and discount rates. Let's calculate the results for each project:
Project P5:
Cash Flows:
Year 0: -1,000
Year 1: 400
Year 2: 400
Year 3: 400
Year 4: 400
Discount rate: 10%
To calculate NPV, we discount each cash flow to its present value and sum them up:
Year 0: -1,000 / (1 + 10%)^0 = -1,000
Year 1: 400 / (1 + 10%)^1 = 363.64
Year 2: 400 / (1 + 10%)^2 = 330.58
Year 3: 400 / (1 + 10%)^3 = 300.53
Year 4: 400 / (1 + 10%)^4 = 273.21
NPV = -1,000 + 363.64 + 330.58 + 300.53 + 273.21 = $268.96
To calculate IRR, we find the rate at which the NPV of the project is zero. We can use a financial calculator or Excel to find the IRR. For project P5, the IRR is approximately 17.40%.
To calculate MIRR, we use a different discount rate for the cash inflows and outflows. We will assume the discount rate for reinvestment is 8%.
Reinvestment Cash Flows:
Year 1: 400 * (1 + 8%)^3 = 487.98
Year 2: 400 * (1 + 8%)^2 = 432.64
Year 3: 400 * (1 + 8%)^1 = 380.80
Year 4: 400 * (1 + 8%)^0 = 400
Discounted Cash Flows:
Year 0: -1,000 / (1 + 10%)^0 = -1,000
Year 1: 487.98 / (1 + 10%)^1 = 443.61
Year 2: 432.64 / (1 + 10%)^2 = 391.82
Year 3: 380.80 / (1 + 10%)^3 = 346.18
Year 4: 400 / (1 + 10%)^4 = 273.21
MIRR = ([Sum of Positive Cash Flows at Reinvestment Rate] / [Sum of Negative Cash Flows at Finance Rate])^(1/n) - 1
MIRR = (487.98 + 432.64 + 380.80 + 400) / (-1,000)^(1/4) - 1
MIRR = 1.6955 - 1
MIRR = 0.6955 or 69.55%
To calculate the profitability index, we divide the present value of cash inflows by the present value of cash outflows:
PV of Cash Inflows = 363.64 + 330.58 + 300.53 + 273.21 = 1,268.96
PV of Cash Outflows = 1,000
Profitability Index = PV of Cash Inflows / PV of Cash Outflows = 1,268.96 / 1,000 = 1.27
To calculate the payback period, we find the time it takes for the cumulative cash inflows to equal or exceed the initial investment:
Year 0: -1,000
Year 1: -1,000 + 400 = -600
Year 2: -600 + 400 = -200
Year 3: -200 + 400 = 200
Year 4: 200 + 400 = 600
The payback period occurs between Year 3 and Year 4, where the cumulative cash inflows exceed the initial investment. Assuming equal cash flows throughout the year, the payback period is between 3 and 4 years.
It's important to note that the profitability index, payback period, and MIRR do not provide a conclusive decision on whether to undertake a project. These measures are additional metrics that can be considered alongside NPV and IRR.
Now, to answer the question of whether these projects should be done:
If the projects are mutually exclusive, meaning you can choose only one, you should consider the one with the highest NPV or highest profitability index, depending on your decision criteria. In this case, we do not have the data for other projects, so we cannot compare them.
If the projects are independent, meaning you can undertake multiple projects, you should consider all the projects with a positive NPV or profitability index. If the MIRR is higher than the cost of capital, it further supports the decision to undertake the project.
Therefore, based on the given data, Project P5 should be undertaken as it has a positive NPV, positive profitability index, and a MIRR higher than the cost of capital.