Concept explainers
It is January 1 of year 0, and Merck is trying to determine whether to continue development of a new drug. The following information is relevant. You can assume that all cash flows occur at the ends of the respective years.
- Clinical trials (the trials where the drug is tested on humans) are equally likely to be completed in year 1 or 2.
- There is an 80% chance that clinical trials will succeed. If these trials fail, the FDA will not allow the drug to be marketed.
- The cost of clinical trials is assumed to follow a triangular distribution with best case $100 million, most likely case $150 million, and worst case $250 million. Clinical trial costs are incurred at the end of the year clinical trials are completed.
- If clinical trials succeed, the drug will be sold for five years, earning a profit of $6 per unit sold.
- If clinical trials succeed, a plant will be built during the same year trials are completed. The cost of the plant is assumed to follow a triangular distribution with best case $1 billion, most likely case $1.5 billion, and worst case $2.5 billion. The plant cost will be
depreciated on a straight-line basis during the five years of sales. - Sales begin the year after successful clinical trials. Of course, if the clinical trials fail, there are no sales.
- During the first year of sales, Merck believe sales will be between 100 million and 200 million units. Sales of 140 million units are assumed to be three times as likely as sales of 120 million units, and sales of 160 million units are assumed to be twice as likely as sales of 120 million units.
- Merck assumes that for years 2 to 5 that the drug is on the market, the growth rate will be the same each year. The annual growth in sales will be between 5% and 15%. There is a 25% chance that the annual growth will be 7% or less, a 50% chance that it will be 9% or less, and a 75% chance that it will be 12% or less.
- Cash flows are discounted 15% per year, and the tax rate is 40%.
Use simulation to model Merck’s situation. Based on the simulation output, would you recommend that Merck continue developing? Explain your reasoning. What are the three key drivers of the project’s
Want to see the full answer?
Check out a sample textbook solutionChapter 11 Solutions
Practical Management Science
- A project does not necessarily have a unique IRR. (Refer to the previous problem for more information on IRR.) Show that a project with the following cash flows has two IRRs: year 1, 20; year 2, 82; year 3, 60; year 4, 2. (Note: It can be shown that if the cash flow of a project changes sign only once, the project is guaranteed to have a unique IRR.)arrow_forwardIn the financial world, there are many types of complex instruments called derivatives that derive their value from the value of an underlying asset. Consider the following simple derivative. A stocks current price is 80 per share. You purchase a derivative whose value to you becomes known a month from now. Specifically, let P be the price of the stock in a month. If P is between 75 and 85, the derivative is worth nothing to you. If P is less than 75, the derivative results in a loss of 100(75-P) dollars to you. (The factor of 100 is because many derivatives involve 100 shares.) If P is greater than 85, the derivative results in a gain of 100(P-85) dollars to you. Assume that the distribution of the change in the stock price from now to a month from now is normally distributed with mean 1 and standard deviation 8. Let EMV be the expected gain/loss from this derivative. It is a weighted average of all the possible losses and gains, weighted by their likelihoods. (Of course, any loss should be expressed as a negative number. For example, a loss of 1500 should be expressed as -1500.) Unfortunately, this is a difficult probability calculation, but EMV can be estimated by an @RISK simulation. Perform this simulation with at least 1000 iterations. What is your best estimate of EMV?arrow_forwardYou are managing a portfolio of $1 million. Your target duration is 11 years, and you can choose from two assets: a zero coupon bond with maturity 5 years, and a perpetuity, the yield is: A. .688 B. .417 C. .583 D. .312arrow_forward
- In an economy, the capital share of GDP is about 30 percent, the average growth in output is about 3 percent per year, the depreciation rate is about 4 percent per year, and the capital–output ratio is about 2.5. Suppose that the production function is Cobb–Douglas, so that the capital share in output is constant, and that the economy has been in a steady state. a. What must the saving rate be in the initial steady state? b. What is the marginal product of capital in the initial steady state? c. Suppose that public policy raises the saving rate so that the economy reaches the Golden Rule level of capital. What will the marginal product of capital be at the Golden Rule steady state? Compare the marginal product at the Golden Rule steady state to the marginal product in the initial steady state. Explain. d. What will the capital–output ratio be at the Golden Rule steady state? e. What must the saving rate be to reach the Golden Rule steady state?arrow_forwardYou are planning to save for retirement over the next 30 years.To do this, you will invest $800 a month in a stock account and $350 a month in abond account. The return of the stock account is expected to be 11 percent, and thebond account will pay 6 percent. When you retire, you will combine your money intoan account with an 8 percent return. How much can you withdraw each month fromyour account assuming a 25-year withdrawal period?arrow_forwardOn Monday, a certain stock closed at $10 per share. Before the stock market opens on Tuesday, you expect the stock to close at $9, $10, or $11 per share, with respective probabilities 0.3, 0.3, and 0.4. Looking ahead to Wednesday, you expect the stock to close 10 percent lower, unchanged, or 10 percent higher than Tuesday’s close, with the following probabilities. Tuesday's Close 10 Percent Lower Unchanged 10 Percent Higher $9 0.4 0.3 0.3 10 0.2 0.2 0.6 11 0.1 0.2 0.7 Early on Tuesday, you are directed to buy 100 shares of the stock before Thursday. All purchases are made at the end of the day, at the known closing price for that day, so your only options are to buy at the end of Tuesday or at the end of Wednesday. You wish to determine the optimal strategy for whether to buy on Tuesday or defer the purchase until Wednesday, given the Tuesday closing price, to minimize the expected purchase price. Develop and evaluate a decision tree. a-1. Determine the optimal…arrow_forward
- In the context of capital budgeting, risk refers toSelect one: a.the chance that the internal rate of return will exceed the cost of capital b.the degree of variability of the initial investment. c.the degree of variability of the cash inflows. d.the chance that the net present value will be greater thanzero.arrow_forwardSuppose you currently have a portfolio of three stocks, A, B, and C. You own 500 shares of A, 300 of B, and 1000 of C. The current share prices are 42.76, 81.33, and, 58.22, respectively. You plan to hold this portfolio for at least a year. During the coming year, economists have predicted that the national economy will be awful, stable, or great with probabilities 0.2, 0.5, and 0.3. Given the state of the economy, the returns (one-year percentage changes) of the three stocks are independent and normally distributed. However, the means and standard deviations of these returns depend on the state of the economy, as indicated in the file P11_23.xlsx. a. Use @RISK to simulate the value of the portfolio and the portfolio return in the next year. How likely is it that you will have a negative return? How likely is it that you will have a return of at least 25%? b. Suppose you had a crystal ball where you could predict the state of the economy with certainty. The stock returns would still be uncertain, but you would know whether your means and standard deviations come from row 6, 7, or 8 of the P11_23.xlsx file. If you learn, with certainty, that the economy is going to be great in the next year, run the appropriate simulation to answer the same questions as in part a. Repeat this if you learn that the economy is going to be awful. How do these results compare with those in part a?arrow_forwardYou are considering a 10-year investment project. At present, the expected cash flow each year is 10,000. Suppose, however, that each years cash flow is normally distributed with mean equal to last years actual cash flow and standard deviation 1000. For example, suppose that the actual cash flow in year 1 is 12,000. Then year 2 cash flow is normal with mean 12,000 and standard deviation 1000. Also, at the end of year 1, your best guess is that each later years expected cash flow will be 12,000. a. Estimate the mean and standard deviation of the NPV of this project. Assume that cash flows are discounted at a rate of 10% per year. b. Now assume that the project has an abandonment option. At the end of each year you can abandon the project for the value given in the file P11_60.xlsx. For example, suppose that year 1 cash flow is 4000. Then at the end of year 1, you expect cash flow for each remaining year to be 4000. This has an NPV of less than 62,000, so you should abandon the project and collect 62,000 at the end of year 1. Estimate the mean and standard deviation of the project with the abandonment option. How much would you pay for the abandonment option? (Hint: You can abandon a project at most once. So in year 5, for example, you abandon only if the sum of future expected NPVs is less than the year 5 abandonment value and the project has not yet been abandoned. Also, once you abandon the project, the actual cash flows for future years are zero. So in this case the future cash flows after abandonment should be zero in your model.)arrow_forward
- A European put option allows an investor to sell a share of stock at the exercise price on the exercise data. For example, if the exercise price is 48, and the stock price is 45 on the exercise date, the investor can sell the stock for 48 and then immediately buy it back (that is, cover his position) for 45, making 3 profit. But if the stock price on the exercise date is greater than the exercise price, the option is worthless at that date. So for a put, the investor is hoping that the price of the stock decreases. Using the same parameters as in Example 11.7, find a fair price for a European put option. (Note: As discussed in the text, an actual put option is usually for 100 shares.)arrow_forwardSuppose that you want to invest $10,000 in the stock market by buying shares in one of two companies: A and B. Shares in company A though risky, could yield a 50% return on investment during the next year. If the stock market if conditions are not favorable (bear market) the stock may lose 20% of it value. Company B provides safe investments with 15% return in a bull market and only 5% in a bear market Ali the applications you have consulted are predicting a 60% chance for a bull market and 40% for a bear market. Where you invest your money? Construct a decision tree.arrow_forwardWhere a financial institution makes a loan commitment, the borrower, in drawing down on their loan commitment, causes increased cash flow needs by the DI to fund the loan commitments. There are three ways a DI can offset the effect of Asset-side liquidity risk such as drawing down of a loan commitment in all of the following sitiuations Except: a. Reduce excess cash reserves to minimum levels required to meet reserve requirements based on the decision made by management independant of regulatory requirements. b. Reduce balance sheet items such as retain earnings to the meet the minimum required capital levels. c. Taking offsetting measures such as borrowing funds or even purchasing funds on the money market. d. Reducing liquid type assets on their balance sheet such at T-bills by selling them.arrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,