You are trying to decide whether to make an investment of $500 million
Problem 22-2 You are trying to decide whether to make an investment of $500 million in a new technology to produce Everlasting Gobstoppers. There is a 60% chance that the market for these candies will produce profits of $100 million annually, a 20% chance the market will produce profits of $50 million, and a 20% chance that there will be no profits. The size of the market will become clear one year from now. Currently, the cost of capital of the project is 11% per year. There is a 20% chance that the cost of capital will drop to 9% in a year and stay at that level forever, and a 80% chance that it will stay at 11% forever. Movements in the cost of capital are unrelated to the size of the candy market. Construct the decision tree that shows the choices you have to make to see if you make the investment either today or one year from now.
Requirements To calculate the expected return on the investment opportunity, we need to construct the decision tree of outcome probabilities. 1. For the first possible outcome, in cell H15, by using cell references, input the first possible profit (1 pt.). In cell G15, by using cell references, input the probability that this outcome will occur (1 pt.). 2. For the second possible outcome, in cell H21, by using cell references, input the second possible profit (1 pt.). In cell G21, by using cell references, input the probability that this outcome will occur (1 pt.). 3. For the third possible outcome, in cell H27, by using cell references, input the third possible profit (1 pt.). In cell G27, by using cell references, input the probability that this outcome will occur (1 pt.). 4.Independent of the profits outcome, there are two possible costs of capital with their respective probabilities of occurrence. For the first possible profit outcome, in cell J14, by using cell references, input the probability that the first cost of capital will occur (1 pt.). 5.In cell J16, by using cell references, input the probability that the second cost of capital will occur (1 pt.). 6. For the second possible profit outcome, in cell J20, by using cell references, input the probability that the first cost of capital will occur (1 pt.). 7.In cell J22, by using cell references, input the probability that the second cost of capital will occur (1 pt.). 8. For the third possible profit outcome, in cell J26, by using cell references, input the probability that the first cost of capital will occur (1 pt.). 9.In cell J28, by using cell references, input the probability that the second cost of capital will occur (1 pt.). 10. For the first possible profit outcome, calculate the NPV of the investment opportunity for both possible costs of capital. In cell K13, by using cell references, calculate the NPV (1 pt.). 11. In cell K17, by using cell references, calculate the NPV (1 pt.). 12. For the second possible profit outcome, calculate the NPV of the investment opportunity for both possible costs of capital. In cell K19, by using cell references, calculate the NPV (1 pt.). 13. In cell K23, by using cell references, calculate the NPV (1 pt.). 14. For the third possible profit outcome, calculate the NPV of the investment opportunity for both possible costs of capital. In cell K25, by using cell references, calculate the NPV (1 pt.). 15. In cell K29, by using cell references, calculate the NPV (1 pt.). 16. Finally, in cell E21, by using cell references, calculate the expected value of the investment opportunity (1 pt.).
ATTACHMENT PREVIEW Download attachment
Problem 22-2Investment (million)$500.00$100.00$50.00$0.00ExpectedValueDecision tree ($ million):You are trying to decide whether to make an investment of $500 millionGobstoppers. There is a 60% chance that the market for these candies w20% chance the market will produce profits of $50 million, and a 20% cthe market will become clear one year from now. Currently, the cost of20% chance that the cost of capital will drop to 9% in a year and stay atstay at 11% forever. Movements in the cost of capital are unrelated to thdecision tree that shows the choices you have to make to see if you maknow.Profits(million)
Background image of page 1
View the Answer
Requirements1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.To calculate the expected return on the investment opportunity, wprobabilities.For the first possible outcome, in cellH15, by using cell referencG15, by using cell references, input the probability that this outcFor the second possible outcome, in cellH21, by using cell refercellG21, by using cell references, input the probability that this oFor the third possible outcome, in cellH27, by using cell referenG27, by using cell references, input the probability that this outcIndependent of the profits outcome, there are two possible costs ooccurrence. For the first possible profit outcome, in cellJ14, by uthe first cost of capital will occur(1 pt.).In cellJ16, by using cell references, input the probability that theFor the second possible profit outcome, in cellJ20, by using cellof capital will occur(1 pt.).In cellJ22, by using cell references, input the probability that theFor the third possible profit outcome, in cellJ26, by using cell reof capital will occur(1 pt.).In cellJ28, by using cell references, input the probability that theFor the first possible profit outcome, calculate the NPV of the invcapital. In cellK13, by using cell references, calculate the NPV(In cellK17, by using cell references, calculate the NPV(1 pt.).For the second possible profit outcome, calculate the NPV of thecapital. In cellK19, by using cell references, calculate the NPV(In cellK23, by using cell references, calculate the NPV(1 pt.).For the third possible profit outcome, calculate the NPV of the incapital. In cellK25, by using cell references, calculate the NPV(In cellK29, by using cell references, calculate the NPV(1 pt.).Finally, in cellE21, by using cell references, calculate the expect
Background image of page 2
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code “Newclient”
The post You are trying to decide whether to make an investment of $500 million appeared first on Superb Professors.
For any questions, feedback, or comments, we have an ethical customer support team that is always waiting on the line for your inquiries.