Question

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

An oil-drilling company must choose between two mutually exclusive extraction projects, and each requires an initial outlay at t = 0 of $12.8 million. Under Plan A, all the oil would be extracted in 1 year, producing a cash flow at t = 1 of $15.36 million. Under Plan B, cash flows would be $2.2744 million per year for 20 years. The firm's WACC is 11.3%.

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

    Discount Rate NPV Plan A NPV Plan B
    0 % $    million     $    million    
    5   million   million
    10   million   million
    12   million   million
    15   million   million
    17   million   million
    20   million   million

    Identify each project's IRR. Do not round intermediate calculations. 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.

    ---- %

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
An oil-drilling company must choose between two mutually exclusive extraction projects, and each requires an initial...
An oil-drilling company must choose between two mutually exclusive extraction projects, and each requires an initial outlay at t = 0 of $11 million. Under Plan A, all the oil would be extracted in 1 year, producing a cash flow at t = 1 of $13.2 million. Under Plan B, cash flows would be $1.9546 million per year for 20 years. The firm's WACC is 12.8%. Construct NPV profiles for Plans A and B. Enter your answers in millions. For...
An oil-drilling company must choose between two mutually exclusive extraction projects, and each requires an initial...
An oil-drilling company must choose between two mutually exclusive extraction projects, and each requires an initial outlay at t = 0 of $12.8 million. Under Plan A, all the oil would be extracted in 1 year, producing a cash flow at t = 1 of $15.36 million. Under Plan B, cash flows would be $2.2744 million per year for 20 years. The firm's WACC is 11.1%. Construct NPV profiles for Plans A and B. Enter your answers in millions. For...
An oil-drilling company must choose between two mutually exclusive extraction projects, and each requires an initial...
An oil-drilling company must choose between two mutually exclusive extraction projects, and each requires an initial outlay at t = 0 of $11.6 million. Under Plan A, all the oil would be extracted in 1 year, producing a cash flow at t = 1 of $13.92 million. Under Plan B, cash flows would be $2.0612 million per year for 20 years. The firm's WACC is 12.1%. Construct NPV profiles for Plans A and B. Enter your answers in millions. For...
An oil-drilling company must choose between two mutually exclusive extraction projects, and each requires an initial...
An oil-drilling company must choose between two mutually exclusive extraction projects, and each requires an initial outlay at t = 0 of $13 million. Under Plan A, all the oil would be extracted in 1 year, producing a cash flow at t = 1 of $15.6 million. Under Plan B, cash flows would be $2.31 million per year for 20 years. The firm's WACC is 12.2%. Construct NPV profiles for Plans A and B. Enter your answers in millions. For...
An oil-drilling company must choose between two mutually exclusive extraction projects, and each requires an initial...
An oil-drilling company must choose between two mutually exclusive extraction projects, and each requires an initial outlay at t = 0 of $11.6 million. Under Plan A, all the oil would be extracted in 1 year, producing a cash flow at t = 1 of $13.92 million. Under Plan B, cash flows would be $2.0612 million per year for 20 years. The firm's WACC is 12.7%. Construct NPV profiles for Plans A and B. Enter your answers in millions. For...
An oil-drilling company must choose between two mutually exclusive extraction projects, and each requires an initial...
An oil-drilling company must choose between two mutually exclusive extraction projects, and each requires an initial outlay at t = 0 of $11.6 million. Under Plan A, all the oil would be extracted in 1 year, producing a cash flow at t = 1 of $13.92 million. Under Plan B, cash flows would be $2.0612 million per year for 20 years. The firm's WACC is 11.3%. Construct NPV profiles for Plans A and B. Enter your answers in millions. For...
An oil-drilling company must choose between two mutually exclusive extraction projects, and each requires an initial...
An oil-drilling company must choose between two mutually exclusive extraction projects, and each requires an initial outlay at t = 0 of $11.6 million. Under Plan A, all the oil would be extracted in 1 year, producing a cash flow at t = 1 of $13.92 million. Under Plan B, cash flows would be $2.0612 million per year for 20 years. The firm's WACC is 12.2%. Construct NPV profiles for Plans A and B. Enter your answers in millions. For...
A company is considering two mutually exclusive expansion plans. Plan A requires a $40 million expenditure...
A company is considering two mutually exclusive expansion plans. Plan A requires a $40 million expenditure on a large-scale integrated plant that would provide expected cash flows of $6.39 million per year for 20 years. Plan B requires a $12 million expenditure to build a somewhat less efficient, more labor-intensive plant with an expected cash flow of $2.69 million per year for 20 years. The firm's WACC is 11%. The data has been collected in the Microsoft Excel Online file...
NPV Your division is considering two projects with the following cash flows (in millions): 0 1...
NPV Your division is considering two projects with the following cash flows (in millions): 0 1 2 3 Project A -$21 $14 $9 $3 Project B -$35 $20 $8 $15 What are the projects' NPVs assuming the WACC is 5%? Round your answer to two decimal places. Do not round your intermediate calculations. Enter your answer in millions. For example, an answer of $10,550,000 should be entered as 10.55. Negative value should be indicated by a minus sign. Project A...
NPV Your division is considering two projects with the following cash flows (in millions): 0 1...
NPV Your division is considering two projects with the following cash flows (in millions): 0 1 2 3 Project A -$29 $15 $13 $3 Project B -$16 $8 $3 $6 What are the projects' NPVs assuming the WACC is 5%? Round your answer to two decimal places. Do not round your intermediate calculations. Enter your answer in millions. For example, an answer of $10,550,000 should be entered as 10.55. Negative value should be indicated by a minus sign. Project A    $...