Question

In: Finance

(Note: show your work, do not use excel) Real Options and Option to Abandon Problem: An...

(Note: show your work, do not use excel) Real Options and Option to Abandon Problem: An integrated oil company is evaluating the exploration and development of an oil field. Initial investment of $100 mil is needed for start-up costs. After a year of start-up, three levels of oil are expected to be uncovered. There is a 20% chance of getting a high level with expected annual FCFF of $25 mil for 20 years; a 60% chance that annual FCFF will be $15 mil for 20 years; and a 20% chance that the operation will be unsuccessful and produce $-6 mil annual FCFF for 20 years. (Note all the expected FCFFs start from year 2.) Assume the cost of capital is 10%.

A. What is the NPV of the project ignoring any option?

B. If project can be abandoned at the end of the start-up phase after the outcome is revealed, what is the NPV with this abandon option? Assuming the cost of shutting down the operation is $5 million.

C. What is the value of the option?

Solutions

Expert Solution

Case 1:

There is a 20% chance of getting a high level with expected annual FCFF of $25 mil for 20 years;

p1 = 20%; FCFF from year 2 onwards = C = 25; n = 20; r = 10%

PV of FCFF at the end of year 1 = C/r x [1 - (1 + r)-n] = 25/10% x [1 - (1 + 10%)-20] = 212.84

Hence, PV of FCFF today = 212.84 / (1 + r) = 212.84 / (1 + 10%) = 193.49

Hence, NPV1 = - C0 + PV of FCFF today = -100 + 193.49 = $ 93.49 million

Case 2:

A 60% chance that annual FCFF will be $15 mil for 20 years;

p2 = 60%; FCFF from year 2 onwards = C = 15; n = 20; r = 10%

PV of FCFF at the end of year 1 = C/r x [1 - (1 + r)-n] = 15/10% x [1 - (1 + 10%)-20] = 127.70

Hence, PV of FCFF today = 127.70 / (1 + r) = 127.70 / (1 + 10%) = 116.09

Hence, NPV2 = - C0 + PV of FCFF today = -100 + 116.09 = $ 16.09 million

Case 3:

A 20% chance that the operation will be unsuccessful and produce $-6 mil annual FCFF for 20 years.

p3 = 20%; FCFF from year 2 onwards = C = -6; n = 20; r = 10%

PV of FCFF at the end of year 1 = C/r x [1 - (1 + r)-n] = -6/10% x [1 - (1 + 10%)-20] = -51.08

Hence, PV of FCFF today = -51.08 / (1 + r) = -51.08 / (1 + 10%) = -46.44

Hence, NPV2 = - C0 + PV of FCFF today = -100 + (-46.44) = - $ 146.44 million

A. What is the NPV of the project ignoring any option?

NPV = p1 x NPV1 + p2 x NPV2 + p3 x NPV3 = 20% x 93.49 + 60% x 16.09 + 20% x (-146.44) = - $ 0.9331 million (Please note that NPV is negative, there is a negative sign before the figure)

B. If project can be abandoned at the end of the start-up phase after the outcome is revealed, what is the NPV with this abandon option? Assuming the cost of shutting down the operation is $5 million.

NPV in case 3 = NPV3 will now be = -C0 + C/(1 + r) = -100 - 5/(1 + 10%) = - $ 104.55 million

Hence, NPV = p1 x NPV1 + p2 x NPV2 + p3 x NPV3 = 20% x 93.49 + 60% x 16.09 + 20% x (-104.55) = $ 7.4454 million

C. What is the value of the option?

The value of the option = NPV in part B - NPV in part A = 7.4454 - (-0.9331) = $ 8.3784 million


Related Solutions

Note: You need to show your work. If you choose to use Excel for your calculations,...
Note: You need to show your work. If you choose to use Excel for your calculations, be sure to upload your well-documented Excel and to make note in this file how you arrived at your answers. If you choose to do the work by hand, Microsoft Word has an equation editor. Go to “Insert” and “Equation” on newer versions of Word. On older versions, go to “Insert” and “Object” and “Microsoft Equation.” Chapter 8 Reflection: The National Center for Education...
Note: You need to show your work. If you choose to use Excel for your calculations,...
Note: You need to show your work. If you choose to use Excel for your calculations, be sure to upload your well-documented Excel and to make note in this file how you arrived at your answers. If you choose to do the work by hand, Microsoft Word has an equation editor. Go to “Insert” and “Equation” on newer versions of Word. On older versions, go to “Insert” and “Object” and “Microsoft Equation.” Chapter 9 Reflection: Annual expenditures for prescription drugs...
Formulate the problem as a linear programming model use excel and show your excel work. Thank...
Formulate the problem as a linear programming model use excel and show your excel work. Thank you. To (cost, in 100's) From New york Philadelphia Chicago Boston Supply Tampa $9 $14 $12 $17 200 Miami 11 10 6 10 200 Fresno 12 8 15 7 200 Demand 130 170 100 50
Show your work with excel The operations manager at XYZ manufacturing is analyzing options for a...
Show your work with excel The operations manager at XYZ manufacturing is analyzing options for a new production line. He can refurbish some old equipment for $70,000 or purchase new equipment for $130,000. The variable costs per unit will be quite different in each case. If he refurbishes, variable cost per unit will be $7.25; if he purchases new equipment, variable cost per unit will be $4.75.    The product will sell for $10 per unit. a. Create a profit model...
Note: You need to show your work. Be sure to upload your well-documented Excel and to...
Note: You need to show your work. Be sure to upload your well-documented Excel and to make note in this file how you arrived at your answers. If you choose to do the work by hand, Microsoft Word has an equation editor. Go to “Insert” and “Equation” on newer versions of Word. On older versions, go to “Insert” and “Object” and “Microsoft Equation.” Player Round 1 Round 2 Michael Letzig 70 72 Scott Verplank 71 72 D.A. Points 70 75...
Please Use Excel To Show All Work, I will like your asnwer if you do this...
Please Use Excel To Show All Work, I will like your asnwer if you do this :) 15.35 Refer to the Johnson Filtration problem introduced in this section. Suppose that in addition to information on the number of months since the machine was serviced and whether a mechanical or an electrical repair was necessary, the managers obtained a list showing which repairperson performed the service. The revised data follow. Repair Time in Hours Months Since Last Service Type of Repair...
SHOW YOUR WORK, DO NOT USE EXCEL Consider a portfolio consisting of the following two assets:...
SHOW YOUR WORK, DO NOT USE EXCEL Consider a portfolio consisting of the following two assets:  Stock A has E[RA] = 10% and ?? = 20%  Stock B has E[RB] = 20% and ?? = 40% Calculate the expected return and standard deviation of the portfolio under the four following sets of assumptions: (a) wA = 1/2 and wB = 1/2 and ???= 0 (b) wA = 1/2 and wB = 1/2 and ???= -1 (c) wA =...
Use Excel to show your work and include the formula in the cell to show how...
Use Excel to show your work and include the formula in the cell to show how you arrived at your figures. Round percentages (example if 49.2, round to 49). Background: ABC, Inc., produces widgets. The company manufactures three levels of widgets-Economy, Better and Best. Selected information on the widgets is given below. Economy Better Best Selling price per widget $40.00 $60.00 $90.00 Variable expense per widget production $22.00 $27.00 $31.50 Selling (5% of selling price) $2.00 $3.00 $4.50 All sales...
Within capital budgeting decisions, there are three ‘hidden’ options; option to expand, option to abandon and...
Within capital budgeting decisions, there are three ‘hidden’ options; option to expand, option to abandon and timing options. Select one of these options and explain the option in detail with real world example.
Within capital budgeting decisions, there are three ‘hidden’ options; option to expand, option to abandon and...
Within capital budgeting decisions, there are three ‘hidden’ options; option to expand, option to abandon and timing options. Select option to abandon and explain the option in detail with real world example.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT