Please help me to understand the following problem. A detailed excel worksheet and step by step solution is requested.
Problem:
Suppose you own the option to extract 1,000 barrels of oil from public land over the next two years. You are deciding whether to extract the oil immediately, allowing you to sell the oil for $20 per barrel, or to wait until next year to extract the oil and sell it then for an uncertain price. The extraction costs are $17 per barrel. The forward price is $20, and you know that oil prices next year will be either $15 per barrel or $25 per barrel, depending on demand conditions. Are you better off extracting the oil today or waiting one year? Explain how your answer might be different if prices next year are either more or less certain but have the same mean.
The approach to solving the above problem would be descriptive.
When I consider the mean price for next year with 0.5 probabilities for each, i.e moving to $25 or down to $ 15, the mean would be = 0.5 * $ 25 + 0.5 * $ 15 = $ 20.
Now the given spot price is $ 20. However, this is a sure event, without possibilities or involving RISK.
Cost of Extraction is $ 17. Looking at the expected return and the risk involved with almost the same pay-off and uncertainty, the favourable choice would be to enter into contract immediately i.e. for $ 20.
Also since it mentioned in the problem that mean would be same if pricing differs, then also the answer remains the same i.e. entering contract of $ 20. The risk factor or the standard deviation would increase as the value moves above $ 25.
Please help me to understand the following problem. A detailed excel worksheet and step by step...
Analyzing an Oil Lease as an Option to Drill for Oil Suppose you own the option to extract 1,000 barrels of oil from public land over the next two years. You are deciding whether to extract the oil immediately, allowing you to sell the oil for $20 per barrel, or to wait until next year to extract the oil and sell it then for an uncertain price. The extraction costs are $17 per barrel. The forward price is $20, and...
You own an oil well that can produce 100k barrels of oil one year from now. Next year, the price of oil will be either $80/barrel if the economy is good and $40/barrel if the economy is bad. Oil costs $50/barrel to extract. One year forwards for oil has a forward price of $55 and the risk-free rate is 4%. What is the value of the oil well if you have to decide today whether to drill for oil or...
16 Homework Set 3B: Market Demand and Supply 7. Which of the following would decrease the supply of airline travel? a. A reduced number of airline travelers. b. New airlines open and begin providing flights. c. Lower prices for airline tickets. d. Higher fuel costs. Questions 8-10 refer to the following graph, which shows a hypothetical economy's market for oil. Price of Idollars per barrel) 100 200 300 400 Quantity of all millions of barrels per year) 8. What is...
This is a intermediate microeconomics question. Please help me
to solve this problem and write all answers down. Thank you so
much.
3. Would selling oil from the Arctic National wildlife refuge substantially affect oil price given that price elasticity of demand is -0.25, the price elasticity of supply of oil is 0.25, the pre-Arctic National Wildlife Refuge daily world production is 94 million barrels per day, the pre-Arctic National Wildlife Refuge world price is $50 per barrel, and daily...
answer please
Problem 4-28 Valuing a business Permian Partners (PP) produces from aging oil fields in west Texas. Production is 1.82 million barrels per year in 2018, but production is declining at 9% per year for the foreseeable future. Costs of production, transportation, and administration add up to $25.20 per barrel. The average oil price was $65.20 per barrel in 2018. PP has 7.2 million shares outstanding. The cost of capital is 11%. All of PP's net income is distributed...
Problem-01a: Current crude oil price is $52.00 per barrel. You sell (short position) 5, five, crude oil futures contracts at futures price of $54.00 per barrel with maturity of one month. (Size of the contract is 5) Note that the size of one futures contract is 1,000 barrels. What is your profit if the crude oil price is $57.00 at maturity and assume cash settlement for this problem? ii. What is your profit if the crude oil price is $49.00...
Please help me solve these problem step by step
6. A company just paid a dividend of S6.55 on its common stock at the end of last year Dividends next year are expected to be $6.67 and $6.73 the year after that. You believe you can set the stock then for $14.96. If you required rate of return in the stock is 19%. How much are you willing to pay for the stock today? 7. A company has common stock...
Can you help me with the following problem markov chains, explaining the solution step by step An electromagnet may (or may not) change its polarity once per second. The probability that it changes is, respectively, 0.2 or 0.7 depending on whether the current state is +1 or -1. a. Define states and transition matrix b. Suppose the current state is 1, find the probability that it will be again after 4 seconds. c. Within 24 hours. What is the probability...
Hello, can I please get a step by step solution through excel?
Thank you!
You own 2,200 shares of stock in Avondale Corporation. You will receive a dividend of $1.80 per share in one year. In two years, the company will pay a liquidating dividend of $45 per share. The required return on the company's stock is 20 percent. a. Ignoring taxes, what is the current share price of your stock? (Do not round intermediate calculations and round your answer...
I need someone to show me step by step explanations. If you use
excel please attach two photos, one showing the results in each
cell. Plus another photo showing the formula in the cell. Also
please highlight the results for a, b, c and d.
Question 18 is worth 15 points 18.Black Diamond, Inc., a manufacturer of carbon and graphite products for the aerospace and transportation industries, is considering several funding alternatives for an investment project. To finance the project,...