CAPACITY PLANNING Real Options Analysis Practice Questions and Solutions CAPACITY PLANNING Question 1: PROJECT SABLE Use a 30% per year discount rate to evaluate Project Sable, which has two phases. You may invest in the first, in both or in neither. You may not invest in the second phase without investing in the first. Phase 1 requires an investment of $100. One year later the project delivers on the average $120. At that time, after the phase 1 payout has been received, you may invest an additional $100 for phase 2. One year later, phase 2 pays out on the average $140. However, phase 2`s payout can go up or down by 20%. a. How much would Project Sable be worth if it offered only the phase 1 opportunity? b. How much would …show more content…
Phase-1 Year Net-cash-flow PV @ 5% NPV Alternative-1 Year Net-cash-flow PV @ 5% NPV Alternative-2 Year Net-cash-flow PV @ 5% NPV CAPACITY PLANNING 0 -300 -300 -7.48 0 0 45.37 0 1 10 9.52 2 12 10.88 3 15 12.96 4 15 12.34 5 15 11.75 6 15 11.19 7 15 10.66 8 15 10.15 9 10 15 315 9.67 193.38 1 0 2 0 3 -240 -207.32 4 10 8.23 5 12 9.40 6 15 11.19 7 15 10.66 8 15 10.15 9 10 15 315 9.67 193.38 1 2 3 4 5 6 -235 -175.3 7 10 7.11 8 12 8.12 9 10 15 315 9.67 193.38 42.92 Phase1+ Alternative-1 Phase 1+ Alternative-2 -7.48+45.37 -7.48+42.92 A1>A2 Question 2: Suppose that discount rate is 5% and volatility is 20%. (c) Do you prefer Alternative 1 or 2 based on real options method? Decide whether the launch of new product is profitable or not based on real options valuation? Alternative-1 Year Revenue Investment CAPACITY PLANNING 0 1 2 3 -240 4 10 5 12 6 15 7 15 8 15 9 15 10 315 Options valuation of Alternative-1: Real Options S = PV(Revenue) X = PV(Investment) A=S/X B = SQRT(T) * sigma 23% of S =58.12 252.69 207.32 1.22 0.35 Question 2: Suppose that discount rate is 5% and volatility is 20%. (c) Do you prefer Alternative 1 or 2 based on real options method? Decide whether the launch of new product is profitable or not based on real options valuation?
a) In the first set of calculations, the staff used a discount rate of 20%, a five-year time horizon, and ignored taxes and terminal value. What is the relative attractiveness of these three alternatives?
General Foods is a large corporation organized by product lines. They are evaluating Super Project, the manufacture of a new powdered dessert. Crosby Sanberg, a financial analysis manager, must determine the value in accepting the proposal, along with J.C. Kresslin, the Corporate Controller. The Super Project will increase profit with a payback period of less than ten years. The proposed capital investment for the project is $200,000 ($80,000 for building modifications and $120,000 for machinery and equipment) and production would take place
a. What makes Arundel think it can make money by buying a package of sequel rights? Is the profit opportunity, if it exists, likely to be sustainable?
c. What is the best evidence of fair value? Describe alternate methods of estimating fair value.
"a. If each project's cost of capital is 12%, which project should be selected? If the cost of capital is 18%, what
Since this project is a going concern, the levered terminal and present values are calculated using the weight average cost of capital (WACC) as the discount rate, which we calculate to be 16.17%.
Free cash flows of the project for next five years can be calculated by adding depreciation values and subtracting changes in working capital from net income. In 2010, there will be a cash outflow of $2.2 million as capital expenditure. In 2011, there will be an additional one time cash outflow of $300,000 as an advertising expense. Using net free cash flow values for next five years and discount rate for discounting, NPV for the project comes out to be $2907, 100. The rate of return at which net present value becomes zero i.e.
See Table 1: Expected non-operating cash flow when the project is terminated at year 4 = 165,880$
b. What happens to the value of the option if you change it to 30%?
3. Compare the two sets of calculations and the corresponding NPVs. How and why do they differ? Which approach should Ariel's financial analyst use?
2. Go through a margin analysis, and determine how much revenue ServiSoft will realize per unit under both distribution options.
10. Returning the cost factor to 100%, what happens to the value of the option if the risk free interest rate doubles to 8%?
The third scenario was ignoring the option to invest in the second-generation project and selling the equipment in year 2. We evaluated this option as a put option. First, we calculated the probabilities for going up and down based on the assumption of a risk neutral word. As a result, the probability of going upward is calculated as 0.3375 and downward probability is 0.6625. In order to determine the present value of all the sequence cash flow at the end of year 2, we calculated the upside change rate and downside change rate as 64.87% and -39.35%, respectfully. The next step is to analyze the option value by using the “Binomial Tree” method. In order to determine the present value of all the subsequence cash flow at the end of year 2, we calculated the cash flow at each node on the tree, until 2006. We discounted all the cash flow at the risk free rate at 10%. The End of Year NPV of all the subsequence cash flow at Year 2 is calculated as $7,571,752, and the selling price of the equipment at end of 2 is $4,000,000, which is the salvage value. We found the NPV of selling the machine at end of Year 2 to be -$2,951,861 as of Year 0, which is negative. The APV of the project after adding the option turned out to be -$6,321,932. This negative APV suggest that the
These two decisions and the net pay off would be influenced by two key uncertainties viz. whether
There are several factors to be considered to calculate the present values (PV) of the first options are: His annual salary at the firm is $60,000 per year, and his salary expected to increase at 3 % per year until retirement, his current average tax rate is 26 % and discount rate is 6.5 percent.