Can you olease show solution in Excel? with formulas in the cells Thank you so much

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 $18 million to invest in new projects this year. Cash Flows (in $ millions) Year CDMA G4 Wi-Fi 0 6 $ 18 $ es 1 $ 12 10 25 18 9 5.5 3.5 WN 16 30 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.) 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 b. G4 Wi-Fi CDMA G4 Wi-Fi NAL . 11 Navt