Valuing an american option: J & B Drilling Company has recently acquired a lease to drill for Natural gas in the remote region of southwest Louisana and southeast Texas. The area has long been known for oil and gas production, and the company is optismistic about the prospects of the lease. The lease contract has a three-year life and allows J &B to begin exploration at any time up until the end of the three-year term. J & B's engineers have have estimated the volume of the natural gas they hope to extract from the leasehold and have placed a value of $25 million on it, on the condition that explorations begin immediately. The cost of developing the property is extimated to be $23 million (regardless of when the property is developed over the next three years). based on the historical volatilities in the returns of the similar investments and other relevant information, j & B's analysts have estimated that the value of the investment opportunity will evolve over the next three years. The risk-free rate of interest is currently 5%, and the risk-natural probability of an uptick in the value of the investment is estimated to be 46.26%. Evaluate the value of the leasedhold as an American call option.What is the lease worth Today? As one of J & B's analysts, what is your recommendation as to when the company should begin drilling? Fill in image above show all work

PROBLEM 12-5: Valuation an American Option Given Risk-neutral probability Risk free Interest rate Discount factor = exp(Risk free interest rate) Strike (in $ millions 0.4626 5% 23.00 Solution Toda Year One Year Two Year Three $ 35.8300 $ 31.7800 $ 28.1900 $ 26.5500 Text Color Legend Value of Beginning Oil Field Operations Now $25.000 $ 23.5500 NPV of waiting (NPV-Waiting) NPV of Exercising Now (NPV-Now) Value of American Option = max (NPV-waiting,NPV-Now) $ 20.8800 $19.6600 Cell Outline Legend Stock Wait $17.4400 14.5700 Exercise a. b. Solution Legend = Value given in problem = Formula/Calculation/Analysis required = Qualitative analysis or short answer required Goal Seek or Solver cell = Crystal Ball Input = Crystal Ball Output