Camer Pharmaceuticals is testing a new product in the market¹. The demand for the new product is estimated to be Normally distributed with a mean 2,000,000 and standard deviation 250,000. The demand is estimated to grow at a rate of 4% per year. The R&D costs are estimated to be between $500 millions of dollars and $800 millions of dollars with a most likely value of $700 millions of dollars. Clinical trial costs are estimated to be between $135 millions of dollars and $160 millions of dollars with a most likely value of $150 millions of dollars. There are competitors in the market, and Camer Pharmaceuticals estimates that their market share in the first year will be any number between 6% and 10%, with each number being equally likely. The company estimates that their market share will grow by 20% each year. A monthly prescription is estimated to generate a revenue of $240. The variable costs are estimated to be $30. Develop a simulation model that calculates the net present value (NPV) of this project over 3 years assuming a discount rate of 10%. Run the simulation for 1000 iterations and answer the following questions.

a.What is the distribution of the NPV (mean and standard deviation)?

b.What are the first quartile, median, and third quartile of NPV?

c.What is the probability that NPV over 3 years will not be positive?

d.What NPV are we likely to observe with a probability of at least 0.9?

e.What cumulative net profit in the third year are we likely to observe with a probability of at least 0.9?

f.What is the 95% confidence interval for the mean NPV? Interpret the resulting confidence interval.

g.What is the number of iterations needed if we want to estimate the NPV within $4,000,000?

h.Interpret the sensitivity chart.