The Seaside Oil and Gas Company is considering drilling three separate fields. Seaside decides to analyze these fields using a \( 10 \% \) discount rate. The cash flows are shown in the following table: \begin{tabular}{llll} years & \( \$ \) & \( \$ \) & \( \$ \) \\ \( \mathbf{0} \) & \( (\$ 85000) \) & \( (\$ 185000) \) & \( (\$ 485000) \) \\ \( \mathbf{1} \) & 40000 & 35000 & 160000 \\ \( \mathbf{2} \) & 30000 & 35000 & 160000 \\ \( \mathbf{3} \) & 30000 & 35000 & 160000 \\ \( \mathbf{4} \) & 25000 & 35000 & 85000 \\ \( \mathbf{5} \) & 20000 & 35000 & 85000 \\ \( \mathbf{6} \) & 10000 & 35000 & 60000 \\ \( \mathbf{7} \) & 0 & 35000 & 30000 \\ \( \mathbf{8} \) & 0 & 35000 & 30000 \\ \( \mathbf{9} \) & 0 & 35000 & 30000 \\ \( \mathbf{1 0} \) & 0 & 35000 & 30000 \end{tabular} Based on the data provided, please calculate the following indicators for this project: a. Calculate the Net Present Value (NPV) of each field b. Calculate the Profit Index (PI) of each field c. Determine the Internal Rate of Return (IRR) of each field d. Based on the results of your calculations, propose to the management of Seaside Oil and Gas Company which project should the company accept and why. Provide a brief explanation to support your proposal.
Added by Robert M.
Close
Step 1
The formula for NPV is: \[ NPV = \sum \frac{C_t}{(1 + r)^t} - C_0 \] where \( C_t \) is the cash flow at time \( t \), \( r \) is the discount rate, and \( C_0 \) is the initial investment. Field 1: - Initial investment: \( C_0 = -85000 \) - Cash flows: \( Show more…
Show all steps
Your feedback will help us improve your experience
Benjamin Densmore and 92 other Algebra educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
A landowner in Texas is offered $250,000 for the exploration rights to oil on her land, along with a 30% royalty on the future profits if oil is discovered. The landowner is also tempted to develop the field herself, believing that the interest in her land is a good indication that oil is present. In that case, she will have to contract a local drilling company to drill an exploratory well on her own. The cost for such a well is $1,000,000, which is lost forever if no oil is found. If oil is discovered, however, the landowner expects to earn future profits of $7,500,000. Finally, the landowner estimates (with the help of her geologist friend) the probability of finding oil on this site to be 25%. What should the landowner do? a. She should develop herself as the EMV of developing herself is 875,000, which is higher than the EMV of selling. b. She should sell as the EMV of selling is 912,500, which is higher than the EMV of developing herself. c. She is indifferent between the two alternatives. d. She should sell as the EMV of developing is less than the cost of $1,000,000.
Sri K.
An oil explorer must decide whether to drill on Site before her option expires or to abandon her rights to the site. Drilling an oil well costs $100,000. If oil is found, the explorer will sell and make a net profit of $500,000 (this includes the cost of drilling). The explorer can hire a geologist to take a seismic test of the site at a cost of $10,000. Such a test reveals, with certainty, whether the geophysical substructure of the land is of type A, type B, or type C, where each type has a different degree of possibility for the existence of oil. From past experience, the probability that a certain substructure will occur, given that oil exists, is as follows: P(type A oil) = 14/28, P(type B oil) = 9/28, P(type C oil) = 5/28. The prior probabilities for the three substructures at the site are: P(type A) = 0.20, P(type B) = 0.30, P(type C) = 0.50. Given that the prior probability P(oil) = 0.28, draw a fully described decision tree for deciding whether the explorer should make the seismic test and whether she should drill for oil or abandon the site following the decision to test or not. In taking the seismic test, the decision about drilling will be made knowing the substructure that exists. Calculate the monetary outcomes (use the explorer's change in assets) of each path in the tree and place each at the end of the appropriate path. Remember that taking the test incurs extra costs. Taking the test improves knowledge about the existence of oil. Calculate the probabilities of finding oil in each of the three types of substructures (i.e., P(oil|type A), P(oil|type B), and P(oil|type C)). Label each chance branch in the tree from (a) with its probability of occurring. What strategy should the explorer follow? Should she pay for the seismic test? Should she drill for oil without taking the test? What decision should be made following the test? What is the maximum amount the explorer should pay for the seismic test (i.e., what is the expected value of sample information; EVSI)? What is the expected value of perfect information (EVPI) about the existence of oil?
Ameer S.
Recommended Textbooks
Elementary and Intermediate Algebra
Algebra and Trigonometry
Watch the video solution with this free unlock.
EMAIL
PASSWORD