Oxford Company has limited funds available for investment and must ration the funds among four competing projects. Selected information on the four projects follows:
Project | Investment Required |
Net Present Value |
Life of the Project (years) |
Internal Rate of Return |
||||
A | $ | 870,000 | $ | 269,397 | 6 | 20 | % | |
B | $ | 680,000 | $ | 304,429 | 11 | 19 | % | |
C | $ | 570,000 | $ | 121,661 | 6 | 17 | % | |
D | $ | 770,000 | $ | 245,189 | 4 | 24 | % | |
The net present values above have been computed using a 10% discount rate. The company wants your assistance in determining which project to accept first, second, and so forth.
Required:
1. Compute the project profitability index for each project.
2. In order of preference, rank the four projects in terms of net present value, project profitability index and internal rate of return.
Solution :
Requirement 1 :
Profitability Index = Present Value of Cash Flow / Initial Investment
Calculation of PI :
Project | Investment (a) | NPV (b) | Present Value of Cash Flows (c) = (a + b) | Profitability Index (d) = (c) / (a) |
A | $ 870,000 | $ 269,397 | $ 1,139,397 | 1.31 |
B | $ 680,000 | $ 304,429 | $ 984,429 | 1.45 |
C | $ 570,000 | $ 121,661 | $ 691,661 | 1.21 |
D | $ 770,000 | $ 245,189 | $ 1,015,189 | 1.32 |
Reqirement 2 : Ranking of Projects
Higher the NPV , Higher the PI and Higher the IRR is crieria for Ranking.
Project A | Project B | Project C | Project D | |
NPV | $ 269,397 | $ 304,429 | $ 121,661 | $ 245,189 |
Rank | 2 | 1 | 4 | 3 |
PI | 1.31 | 1.45 | 1.21 | 1.32 |
Rank | 3 | 1 | 4 | 2 |
IRR | 20% | 19% | 17% | 24% |
Rank | 2 | 3 | 4 | 1 |
Please vote up and write your doubts in comment section. Would be glad to help you further.
Get Answers For Free
Most questions answered within 1 hours.