Economics Homework Help

I don’t understand this Finance question and need help to study.

Using the spreadsheet model in the attahcemnt , perform an NPV analysis of the NetPhone project, using the base case assumptions from the case. You may also assume a risk-free rate of 4.25%, a market risk premium of 5%, and a beta of 1.25 for the project

1) What is the consequence of the following alternative assumptions for your estimate of NPV?

a) Penetration of the new product may be as high as 30%, or as low as 7.5%.
b) Production costs may range from $5/unit to $7.25/unit.
c) The beta of the project might be as low as 1.0 or as high as 2.0.

2) Of the uncertainties in Question #1 above, which would you be most concerned about?

3)Suppose the hardware engineering group believes that by spending $17.5 million rather than $10 million on hardware R&D, they can lower the product’s production cost. By how much would the production cost need to fall, under the base case scenario, to justify this additional investment?

4)Suppose that starting from the base case scenario, you believe the expected market penetration of the product is 12.5%. Assuming your estimates are as accurate as they can be today, should you launch? Why or why not?