Decision Trees, Scenario Analysis | Homework Helper

Decision Trees
You have an option to develop an oil field, which has known reserves of 50,000 barrels. Production costs are $30 per barrel. You may drill the oil in the first year or in the second year, but you must recover all 50,000 barrels at the same time. If you drill in the first period, you may sell the oil at the period one price or store it at a cost of $2 per barrel. You pay storage costs at the time you decide to store the oil.
The current price of oil is $40 per barrel, but the price will increase by 20 percent or decrease by 10 percent each year with equal probability. (So, for example, the price per barrel the first year will be either $48 per barrel or $36 per barrel.)
Construct a decision tree to show all the possible outcomes over the two years and the net income for each outcome. Assume that you must make the decision to drill or not to drill in period one before observing the period one price. If you drill in period one, you must decide to sell or store before observing period two price. If you do not drill in period one, you make the decision whether or not to drill in period two after observing the period one price, but before observing the period two price.
If the discount rate is 10 percent per year, what is the best action to take in each period? What is the expected NPV of the oil concession at time zero (i.e. before the price change in the first period)?
There is a spreadsheet attached that you may use as a guide in solving this problem.
Scenario Analysis
Suppose in the above problem that each year there is a 50 percent probability that the price will increase by 30 percent and a 50 percent probability that the price will not change. How do the above answers change?
Now suppose in the above problem that each year there is a 50 percent probability that the price will increase by 10 percent and a 50 percent probability that the price will decrease by 30 percent. How do the above answers change?
Just need some help setting up and answering this question please. I have an attached file as well to help you out if need be. Thank you.

Don't use plagiarized sources. Get Your Custom Essay on
Decision Trees, Scenario Analysis | Homework Helper
Get an essay WRITTEN FOR YOU, Plagiarism free, and by an EXPERT!
Order Essay
Calculate your paper price
Pages (550 words)
Approximate price: -

Why Choose Us

Top quality papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Professional academic writers

We have hired a team of professional writers experienced in academic and business writing. Most of them are native speakers and PhD holders able to take care of any assignment you need help with.

Free revisions

If you feel that we missed something, send the order for a free revision. You will have 10 days to send the order for revision after you receive the final paper. You can either do it on your own after signing in to your personal account or by contacting our support.

On-time delivery

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & confidential

We use several checkers to make sure that all papers you receive are plagiarism-free. Our editors carefully go through all in-text citations. We also promise full confidentiality in all our services.

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

Total price:

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.


Essay Writing Service

You are welcome to choose your academic level and the type of your paper. Our academic experts will gladly help you with essays, case studies, research papers and other assignments.


Admission help & business writing

You can be positive that we will be here 24/7 to help you get accepted to the Master’s program at the TOP-universities or help you get a well-paid position.


Editing your paper

Our academic writers and editors will help you submit a well-structured and organized paper just on time. We will ensure that your final paper is of the highest quality and absolutely free of mistakes.


Revising your paper

Our academic writers and editors will help you with unlimited number of revisions in case you need any customization of your academic papers