ANALYTIC SOLVER - R&D Planning. A firm is in the process of assessing the economic prospects for a new bottling machine it is developing…

A. What is the expected NPV for this new machine over ten years?

B. What is the probability of a positive NPV?

Please upload screenshots of your steps done in excel - please include solver screenshots

Question:

 Please use this template as your setup in excel = solver

 

2. R&D Planning. A firm is in the process of assessing the economic prospects for a new bottling machine it is develop- ing. Future research and development expenses could range from $4 to $9 million, with a most likely value around $7 million. The life of the product will be anywhere from 3 to 10 years. Yearly unit sales will range from 100 to 500, with a most likely value around 300. The machines will sell for between $20,000 and $25,000 each. The production cost of the machine is expected to be $13,000 but could be as low as $11,000 or as high as $15,000. The firm's discount rate is 10 percent. a. What is the expected NPV for this new machine over ten years? b. What is the probability of a positive NPV?