Question

In: Finance

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 36 45 3 7.5 33 33 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.) Profitability index L6 G5 Wi-Fi b. Calculate the NPV for each investment. (Enter your answers in dollars, not millions of dollars. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 1,234,567.89.) NPV L6 $ G5 $ Wi-Fi $

Solutions

Expert Solution

a. profitability index = sum of present value (PV) of cash inflows/initial investment or cash outflow at Year 0

present value (PV) of cash inflows = Year 1 cash inflow/(1+discount rate) + Year 2 cash inflow/(1+discount rate)2 + Year 3 cash inflow/(1+discount rate)3

profitability index of project L6 is 2.66, project G5 is 3.14 and project Wi-Fi is 2.68.

Project L6 Project G5 Project Wi-Fi
Year Cash flows PV of cash inflows Cash flows PV of cash inflows Cash flows PV of cash inflows
0 -$10 -$23 -$33
1 $14 $12.61 $21 $18.92 $31 $27.93
2 $10.5 $8.52 $36 $29.22 $45 $36.52
3 $7.5 $5.48 $33 $24.13 $33 $24.13
Discount rate 11% 11% 11%
Total $26.62 $72.27 $88.58
Profitability index 2.66 3.14 2.68

Calculations

b. NPV is the difference between sum of present value of cash inflows and initial investment or cash outflow at Year 0.

present value (PV) of cash inflows = Year 1 cash inflow/(1+discount rate) + Year 2 cash inflow/(1+discount rate)2 + Year 3 cash inflow/(1+discount rate)3

NPV of project L6 is $16.62, project G5 is $49.27 and project Wi-Fi is $55.58.

Years Project L6 Project G5 Project Wi-Fi
0 -$10 -$23 -$33
1 $14 $21 $31
2 $10.5 $36 $45
3 $7.5 $33 $33
Discount rate 11% 11% 11%
NPV $16.62 $49.27 $55.58

Calculations


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 –$...
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...
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...
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...
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 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 –$...
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 –$...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT