Question
An oil and gas exploration firm invested $1,500,000 in drilling for natural gas in a new gas field. The firm's geologist believes the field has
An oil and gas exploration firm invested $1,500,000 in drilling for natural gas in a new gas field. The firm's geologist believes the field has the potential to produce gas for many years. The revenue resulting from the gas well the first year after drilling is $500,000; based on previous experiences with similar types of wells, it is expected the annual revenue will decrease at an annual rate of 1%. Likewise, the costs of operating the well the first year totals $160,000; costs are expected to increase at an annual rate of 3%. If the firm's MARR is 19%, how long will it take for the firm to recover its investment? Hint: Using Excel's Goal Seek or SOLVER tool leave cell for the number of years required to recover the investment empty.
n = _______ years
Round entry to 1 decimal place. The tolerance is 0.2.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started