Question

In: Finance

Hanmi Group, a consumer electronics conglomerate, is reviewing its annual budget in wireless technology. It is...

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 12 percent. Further, the company has only $22 million to invest in new projects this year.

  

Cash Flows (in $ millions)
Year CDMA   G4    Wi-Fi
0 –$ 8 –$ 14 –$ 22
1 11 12 20
2 7.5 27 34
3 5.5 22 22

  

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)

Solutions

Expert Solution

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:

  • Press the CF button.
  • CF0= -$8 million. Indicate the initial cash flow by a negative sign since it is a cash outflow.  
  • Cash flow for each year should be entered.
  • Press Enter and down arrow after inputting each cash flow.
  • After entering the last cash flow cash flow, press the NPV button and enter the discount rate of 12%.
  • Press enter after that. Press the down arrow and CPT buttons to get the net present value.  

Net present value at 12% discount rate is $11.72 million.

Profitability Index= $11.72 million + $8 million/ $8 million

= $19.72 million / 8 million

= 1.47.

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:

  • Press the CF button.
  • CF0= -$14 million. Indicate the initial cash flow by a negative sign since it is a cash outflow.  
  • Cash flow for each year should be entered.
  • Press Enter and down arrow after inputting each cash flow.
  • After entering the last cash flow cash flow, press the NPV button and enter the discount rate of 12%.
  • Press enter after that. Press the down arrow and CPT buttons to get the net present value.  

Net present value at 12% discount rate is $33.90 million.

Profitability Index= $33.90 million + $14 million/ $14 million

= $47.90 million / $14 million

= 3.42.

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:

  • Press the CF button.
  • CF0= -$22 million. Indicate the initial cash flow by a negative sign since it is a cash outflow.  
  • Cash flow for each year should be entered.
  • Press Enter and down arrow after inputting each cash flow.
  • After entering the last cash flow cash flow, press the NPV button and enter the discount rate of 12%.
  • Press enter after that. Press the down arrow and CPT buttons to get the net present value.  

Net present value at 12% discount rate is $38.62 million.

Profitability Index= $38.62 million + $22 million/ $22 million

= $60.62 million / $22 million

= 2.76.

b.CDMA

Net present value can be solved using a financial calculator. The steps to solve on the financial calculator:

  • Press the CF button.
  • CF0= -$8 million. Indicate the initial cash flow by a negative sign since it is a cash outflow.  
  • Cash flow for each year should be entered.
  • Press Enter and down arrow after inputting each cash flow.
  • After entering the last cash flow cash flow, press the NPV button and enter the discount rate of 12%.
  • Press enter after that. Press the down arrow and CPT buttons to get the net present value.  

Net present value at 12% discount rate is $11.72 million.

G4

Net present value can be solved using a financial calculator. The steps to solve on the financial calculator:

  • Press the CF button.
  • CF0= -$14 million. Indicate the initial cash flow by a negative sign since it is a cash outflow.  
  • Cash flow for each year should be entered.
  • Press Enter and down arrow after inputting each cash flow.
  • After entering the last cash flow cash flow, press the NPV button and enter the discount rate of 12%.
  • Press enter after that. Press the down arrow and CPT buttons to get the net present value.  

Net present value at 12% discount rate is $33.90 million.

Wi-Fi

Net present value can be solved using a financial calculator. The steps to solve on the financial calculator:

  • Press the CF button.
  • CF0= -$22 million. Indicate the initial cash flow by a negative sign since it is a cash outflow.  
  • Cash flow for each year should be entered.
  • Press Enter and down arrow after inputting each cash flow.
  • After entering the last cash flow cash flow, press the NPV button and enter the discount rate of 12%.
  • Press enter after that. Press the down arrow and CPT buttons to get the net present value.  

Net present value at 12% discount rate is $38.62 million.

In case of any query, kindly comment on the solution.


Related Solutions

Hanmi Group, a consumer electronics conglomerate, is reviewing its annual budget in wireless technology. It is...
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 10 percent. Further, the company has only $22 million to invest in new projects this year.    Cash Flows (in $ millions) Year CDMA   G4    Wi-Fi 0 –$ 7 –$...
Hanmi Group, a consumer electronics conglomerate, is reviewing its annual budget in wireless technology. It is...
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 –$...
Hanmi Group, a consumer electronics conglomerate, is reviewing its annual budget in wireless technology. It is...
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 12 percent. Further, the company has only $25 million to invest in new projects this year.    Cash Flows (in $ millions) Year CDMA   G4 Wi-Fi 0 –$ 6 –$ 19...
Hanmi Group, a consumer electronics conglomerate, is reviewing its annual budget in wireless technology. It is...
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 11 percent. Further, the company has only $23 million to invest in new projects this year.    Cash Flows (in $ millions) Year CDMA   G4    Wi-Fi 0 –$ 5 –$...
Hanmi Group, a consumer electronics conglomerate, is reviewing its annual budget in wireless technology. It is...
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 products is 12 percent. Further, the company has only $26 million to invests in new projects this year. year CDMA G4 Wi-Fi 0 -9 -17 -26 1 14 14 23 2 11.5 28...
Hanmi Group, a consumer electronics conglomerate, is reviewing its annual budget in wireless technology. It is...
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 10 percent. Further, the company has only $21 million to invest in new projects this year.    Cash Flows (in $ millions) Year CDMA   G4    Wi-Fi 0 –$ 4 –$...
Hanmi Group, a consumer electronics conglomerate, is reviewing its annual budget in wireless technology. It is...
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 $29 million to invest in new projects this year.    Cash Flows (in $ millions) Year CDMA   G4    Wi-Fi 0 –$ 8 –$...
Broxton Group, a consumer electronics conglomerate, is reviewing its annual budget in wireless technology. It is...
Broxton 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. Assume the discount rate is 11 percent. Further, the company has only $33 million to invest in new projects this year. Cash Flows (in $ millions) Year L6 G5 Wi-Fi 0 −$ 10.0 −$ 23 −$ 33 1 14.0 21 31 2 10.5...
Broxton Group, a consumer electronics conglomerate, is reviewing its annual budget in wireless technology. It is...
Broxton 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. Assume the discount rate is 10 percent. Further, the company has only $22 million to invest in new projects this year. Cash Flows (in $ millions) Year L6 G5 Wi-Fi 0 −$ 7.0 −$ 15 −$ 22 1 12.0 12 19 2 9.5...
Broxton Group, a consumer electronics conglomerate, is reviewing its annual budget in wireless technology. It is...
Broxton 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. Assume the discount rate is 8 percent. Further, the company has only $16 million to invest in new projects this year. Cash Flows (in $ millions) Year L6 G5 Wi-Fi 0 ?$ 8.0 ?$ 21 ?$ 29 1 12.0 19 27 2 8.5...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT