Question

In: Finance

"An oil and gas company is considering whether to begin drilling a new oil field. The...

"An oil and gas company is considering whether to begin drilling a new oil field. The company will need to pay $4.6 million as an initial investment in order to extract the oil. The company will operate the field for a total of 5 years, during which its annual profit will be $3,344,000. During the 6th year, the company will not operate or gain any revenue from the oil field, but it will need to pay $8,990,000 in environmental remediation costs to return the area to an acceptable state. What is the MAXIMUM interest rate for which this project is an acceptable investment? Enter the interest rate as a percentage. "

Solutions

Expert Solution

For purpose of determining maximum interest ratefor which project remains acceptable, is the IRR at which NPV of project becomes 0 and beyond whichit necomes unacceptable
Rearranging the cash flows in table form
Year Cash Flow
0                              (4,600,000)
1                                 3,344,000
2                                 3,344,000
3                                 3,344,000
4                                 3,344,000
5                                 3,344,000
6                              (8,990,000)
IRR = 58.04%
Excel Fn =IRR(Values 0 to values 6)
So for maximum interest rate of 58.04%, project is acceptable and beyond that rate it is unacceptable

Related Solutions

Black Oil Company is trying to decide whether to lease or buy a new computer-assisted drilling...
Black Oil Company is trying to decide whether to lease or buy a new computer-assisted drilling system for its extraction business. Management has already determined that acquisition of the system has a positive NPV. The system costs $9.4 million and qualifies for a 25% CCA rate. The equipment will have a $975,000 salvage value in five years. Black Oil’s tax rate is 36%, and the firm can borrow at 9%. Cape Town Company has offered to lease the drilling equipment...
Black Oil Company is trying to decide whether to lease or buy a new computer-assisted drilling...
Black Oil Company is trying to decide whether to lease or buy a new computer-assisted drilling system for its extraction business. Management has already determined that acquisition of the system has a positive NPV. The system costs $9.4 million and qualifies for a 25% CCA rate. The equipment will have a $975,000 salvage value in five years. Black Oil’s tax rate is 36%, and the firm can borrow at 9%. Cape Town Company has offered to lease the drilling equipment...
An oil company is drilling a series of new wells on the perimeter of a producing...
An oil company is drilling a series of new wells on the perimeter of a producing oil field. About 17% of the new wells will be dry holes. Even if a new well strikes oil, there is still uncertainty about the amount of oil produced: 40% of new wells that strike oil produce only 2,200 barrels a day; 60% produce 6,200 barrels per day. a. Forecast the annual cash revenues from a new perimeter well. Use a future oil price...
A company is considering drilling four oil wells. The probability of success for each well is...
A company is considering drilling four oil wells. The probability of success for each well is 0.40, independent of the results for any other well. The cost of each well is $200,000. Each well that is successful will be worth $600,000. a) What is the probability that one or more wells will be successful? b) What is the expected number of successes? c) What is the expected gain? d) What will be the gain if only one well is successful?...
A company is considering drilling oil wells. The probability of success for each well is 0.20....
A company is considering drilling oil wells. The probability of success for each well is 0.20. The cost of each well is $5 (in1000). Each well that is successful will be worth $60 (in 1000). 1) If the company drills 4 wells, the probability of at least one successful well is 2) If the company drills 40 wells, the approximate probability of at most one successful well is 3) The expected profit and the variance of profit in 4 drillings...
What are the profit margins at drilling wells, oil refinerys, gas storage places and gas stations?
What are the profit margins at drilling wells, oil refinerys, gas storage places and gas stations?
There are many operations in oil and gas industry such as drilling, casing, cementing, perforation, well...
There are many operations in oil and gas industry such as drilling, casing, cementing, perforation, well logging and well stimulation. Mention the possible hazard (2.5 marks) and safety measures (2.5 marks) that an engineer must keep in mind during cementing operation.
Decision analysis. After careful testing and​ analysis, an oil company is considering drilling in two different...
Decision analysis. After careful testing and​ analysis, an oil company is considering drilling in two different sites. It is estimated that site A will net ​$20 million if successful​ (probability.2) and lose ​$4 million if not​ (probability.8​);site B will net ​$60 million if successful​ (probability.1) and lose ​$5 million if not​ (probability.9​). Which site should the company choose according to the expected return from each​ site?
Ewing Oil Company (EOC) is examining a new oil field. If EOC drills today, it will...
Ewing Oil Company (EOC) is examining a new oil field. If EOC drills today, it will cost $9 million and the oil field is expected to create cash flows of $3.5 million per year for the next 5 years. Alternatively, the company could spend $350,000 today for a geological survey. The survey would take two years and result in a better estimate of the oil field’s resources. There is an 80 percent chance that the survey would find the oil...
Technological innovations in oil drilling have decreased the cost of producing propane gas. a. Show this...
Technological innovations in oil drilling have decreased the cost of producing propane gas. a. Show this change graphically in a supply and demand diagram for propane. Clearly label your curves and equilibrium price and quantity both before and after the change in technology .b. If the demand for propane increases significantly during the summer as more people grill outside, what will be the net impact of this change in demand combined with the change from (a) on market equilibrium price...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT