Use Excel® to solve Problem 6.8 for leverage factors of 0.2 and 0.4.
Problem 6.8
The XYZ oil company owns several natural gas wells and is negotiating a 10-year contract to sell the gas from these wells to another company. They are negotiating on the price of the gas in the first year, in dollars per thousand cubic feet ($/MCF), including a 4% escalation clause. XYZ expects the wells to produce 33,000 MCF the first year and to decline at the rate of 15% every year thereafter. Operating costs are estimated to be $2/MCF and escalate at 3% per year. XYZ has agreed to spend $500,000 now to lay pipelines from each well to the second company's processing plant. What should the minimum price be the first year for this to be acceptable to XYZ? Assume an end-of-year convention and an MARR of 15%.