Reference no: EM132951546
Answer the questions in an Excel table:
Camer Pharmaceuticals is testing a new product in the market1. 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.
|
What is the expected rate of return for an investment
: Using the CAPM and SML, what is the expected rate of return for an investment with a ß of 1.8, a risk free rate of return of 4%, and a market rate of return of
|
|
Calculate change in cash and cash equivalents during year
: Assume the loan is an integral part of cash management. Calculate the change in cash and cash equivalents during the year, and the ending balance
|
|
Why should care about the market price
: If their company isn't getting any money for the shares trading on the secondary market, why should they care about their market price?
|
|
Which statements relating to the accounting for research
: Which statements relating to the accounting for research and development expenditure under IAS 38 is CORRECT? Expenditure on development
|
|
What is the distribution of the npv
: Camer Pharmaceuticals is testing a new product in the market1. The demand for the new product is estimated to be Normally distributed with a mean 2,000,000 and
|
|
Find the variance of the probability distribution
: Find the variance of the probability distribution. Round to 2 decimal places.
|
|
Compare the proportions of users for platform across
: A manager is considering placing an ad campaign on an emerging social media platform (e.g., Snap). To understand the demographics of usage for this platform, th
|
|
Present two different types of data
: -Present two different types of data, or variables, used in the health field. Examples could be blood pressure, temperature, pH, pain rating scales, pulse oxime
|
|
Discuss the concepts of internal alignment
: Discuss the concepts of internal alignment and external competitiveness, how each positively and negatively affects an organization
|