In: Finance
Hanmi Group, a consumer electronics conglomerate, is reviewing its annual budget in wireless technology. It is considering investments in three different technologies to develop wireless communication devices. Consider the following cash flows of the three independent projects available to the company. Assume the discount rate for all projects is 9 percent. Further, the company has only $20 million to invest in new projects this year. |
Cash Flows (in $ millions) |
Year | CDMA | G4 | Wi-Fi | ||||||
0 | –$ | 6 | –$ | 14 | –$ | 20 | |||
1 | 11 | 11 | 17 | ||||||
2 | 8.5 | 25 | 33 | ||||||
3 | 3.5 | 20 | 20 | ||||||
a. |
Calculate the profitability index for each investment. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) |
b. | Calculate the NPV for each investment. (Do not round intermediate calculations and enter your answer in dollars, not millions, rounded to 2 decimal places, e.g., 1,234,567.89) |
a.CDMA
Profitability Index is a ratio of the discounted cash flow to the initial cash flow of the project. It is calculated using the below formula:
Profitability Index= NPV + Initial investment/ Initial investment
Net present value can be solved using a financial calculator. The steps to solve on the financial calculator:
Net present value at 9% discount rate is $13.95 million.
Profitability Index= $13.95 million + $6 million/ $6 million
= $19.95 million / 6 million
= 3.32.
G4
Profitability Index is a ratio of the discounted cash flow to the initial cash flow of the project. It is calculated using the below formula:
Profitability Index= NPV + Initial investment/ Initial investment
Net present value can be solved using a financial calculator. The steps to solve on the financial calculator:
Net present value at 9% discount rate is $32.58 million.
Profitability Index= $32.58 million + $14 million/ $14 million
= $46.58 million / $14 million
= 3.33.
Wi-Fi
Profitability Index is a ratio of the discounted cash flow to the initial cash flow of the project. It is calculated using the below formula:
Profitability Index= NPV + Initial investment/ Initial investment
Net present value can be solved using a financial calculator. The steps to solve on the financial calculator:
Net present value at 9% discount rate is $38.82 million.
Profitability Index= $38.82million + $20 million/ $20 million
= $58.82 million / $20 million
= 2.94.
b.CDMA
Net present value can be solved using a financial calculator. The steps to solve on the financial calculator:
Net present value at 9% discount rate is $13.95 million.
G4
Net present value can be solved using a financial calculator. The steps to solve on the financial calculator:
Net present value at 9% discount rate is $32.58 million.
Wi-Fi
Net present value can be solved using a financial calculator. The steps to solve on the financial calculator:
Net present value at 9% discount rate is $38.82 million.
In case of any query, kindly comment on the solution.