please use excel!!! Gidget has a new widget to bring to market. If the firm goes directly to market with the product, there is a 65% chance of success. However, the firm can conduct customer segment research, which will take a year and cost $5,000,000. By going through research, the company can better target potential customers and increase the probability of success to 80%. If successful, the widget will bring a present value profit (at the time of initial selling) of $80 million. If unsuccessful, the present value profit is only $10 million. The appropriate discount rate is 10%.

A)Calculate the NPV of going directly to the market. (Enter whole numbers, e.g. 5 million should be 5,000,000)

Gidget has a new widget to bring to market. If the firm goes directly to market with the product, there is a 65% chance of success. However, the firm can conduct customer segment research, which will take a year and cost $5,000,000. By going through research, the company can better target potential customers and increase the probability of success to 80%. If successful, the widget will bring a present value profit (at the time of initial selling) of $80 million. If unsuccessful, the present value profit is only $10 million. The appropriate discount rate is 10%.

B)Calculate the NPV for conducting customer segment research. (Enter whole numbers, e.g. 5 million should be 5,000,000)