Question
Problem 7-17 Profitability Index versus NPV Broxton Group, a consumer electronics conglomerate, is reviewing its annual budget in wireless technology. It is considering investments in
Problem 7-17 Profitability Index versus NPV 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 $18 million to invest in new projects this year. Cash Flows (in $ millions) Year L6 G5 Wi-Fi 0 $ 6.0 $ 12 $ 18 1 9.0 10 16 2 5.5 25 30 3 3.5 18 18 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 2.56 2.56 Correct G5 3.61 3.61 Correct Wi-Fi 2.94 2.94 Correct 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 $ 8118707.74 8118707.74 Incorrect G5 $ 37207362.89 37207362.89 Incorrect Wi-Fi $ 34862509.39 34862509.39 Correct
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 $18 million to invest in new projects this year. Cash Flows (in $ millions) Year 1 LG 26.0 9.0 5.5 3.5 G5 -$12 10 25 18 Wi-Fi -$18 16 30 18 WN 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 2.56 3.61 2.94 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.) L6 NPV $ 8118707.74 $ 37207362.89 $ 34862509.39 G5 Wi-Fi 0 1 2 3 L6 G5 WiFi 0.1 (4,000,000.00) (17,000,000.00) (18,000,000.00) 1 8,000,000.00 15,000,000.00 16,000,000.00 0.9090909 4,500,000.00 30,000,000.00 30,000,000.00 0.8264463 1,500,000.00 21,000,000.00 18,000,000.00 0.7513148 NPV (4,000,000.00) 7,272,727.27 3,719,008.26 1,126,972.20 $ 8,118,707.74 4,000,000.00 3.029676935 (17,000,000.00) (18,000,000.00) 13,636,363.64 14,545,454.55 24,793,388.43 24,793,388.43 15,777,610.8213,523,666.42 $ 37,207,362.89 $ 34,862,509.39 17,000,000.00 18,000,000.00 3.188668405 2.936806077Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started