An oil-drilling company must choose between two mutually exclusive extraction projects, and each requires an initial...

90.2K

Verified Solution

Question

Finance

An oil-drilling company must choose between two mutuallyexclusive extraction projects, and each requires an initial outlayat t = 0 of $11.8 million. Under Plan A, all the oil would beextracted in 1 year, producing a cash flow at t = 1 of $14.16million. Under Plan B, cash flows would be $2.0967 million per yearfor 20 years. The firm's WACC is 11.7%.

  1. Construct NPV profiles for Plans A and B. Enter your answers inmillions. For example, an answer of $10,550,000 should be enteredas 10.55. If an amount is zero, enter "0". Negative values, if any,should be indicated by a minus sign. Do not round intermediatecalculations. Round your answers to two decimal places.  

    Discount RateNPV Plan ANPV Plan B
    0%$    million    $    million    
    5  million  million
    10  million  million
    12  million  million
    15  million  million
    17  million  million
    20  million  million
  2. Identify each project's IRR. Do not round intermediatecalculations. Round your answers to two decimal places.

    Project A:   %

    Project B:   %

    Find the crossover rate. Do not round intermediate calculations.Round your answer to two decimal places.

      %

  3. Is it logical to assume that the firm would take on allavailable independent, average-risk projects with returns greaterthan 11.7%?

    If all available projects with returns greater than 11.7% havebeen undertaken, does this mean that cash flows from pastinvestments have an opportunity cost of only 11.7%, because all thecompany can do with these cash flows is to replace money that has acost of 11.7%?

    Does this imply that the WACC is the correct reinvestment rateassumption for a project's cash flows?

Answer & Explanation Solved by verified expert
3.6 Ratings (692 Votes)
SEE THE    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

An oil-drilling company must choose between two mutuallyexclusive extraction projects, and each requires an initial outlayat t = 0 of $11.8 million. Under Plan A, all the oil would beextracted in 1 year, producing a cash flow at t = 1 of $14.16million. Under Plan B, cash flows would be $2.0967 million per yearfor 20 years. The firm's WACC is 11.7%.Construct NPV profiles for Plans A and B. Enter your answers inmillions. For example, an answer of $10,550,000 should be enteredas 10.55. If an amount is zero, enter "0". Negative values, if any,should be indicated by a minus sign. Do not round intermediatecalculations. Round your answers to two decimal places.  Discount RateNPV Plan ANPV Plan B0%$    million    $    million    5  million  million10  million  million12  million  million15  million  million17  million  million20  million  millionIdentify each project's IRR. Do not round intermediatecalculations. Round your answers to two decimal places.Project A:   %Project B:   %Find the crossover rate. Do not round intermediate calculations.Round your answer to two decimal places.  %Is it logical to assume that the firm would take on allavailable independent, average-risk projects with returns greaterthan 11.7%?If all available projects with returns greater than 11.7% havebeen undertaken, does this mean that cash flows from pastinvestments have an opportunity cost of only 11.7%, because all thecompany can do with these cash flows is to replace money that has acost of 11.7%?Does this imply that the WACC is the correct reinvestment rateassumption for a project's cash flows?

Other questions asked by students