Question

An oil-drilling company must choose between two mutually exclusive extraction projects, and each requires an initial outlay at t 0 of $12.6 million. Under Plan A, all the oil would be extracted in 1 year, producing a cash flow at t 1 of $15.12 million. Under Plan B, cash flows would be $2.2389 million per year for 20 years. The firm's WACC is 12.5% a. 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 NPV Plan A Discount Rate NPV Plan B million $ 0% $ million 5 million million 10 million million million 12. million million million 15 million million 17 million million 20 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 % b. Is it logical to assume that the firm would take on all available independent, average-risk projects with returns greater than 12.5%? -Select- If all available projects with returns greater than 12.5% have been undertaken, does this mean that cash flows from past investments have an opportunity cost of only 12.5%, because all the company can do with these cash flows is to replace money that has a cost of 12.5%? -Select- Does this imply that the WACC is the correct reinvestment rate assumption for a project's cash flows?

Answer 1

5 NMODE 7$ - - $ $_2 B26 : X V fx =IRR(B4:B24) A B C D E F G 1. Cash flows PVIF@12.5% Present value Year Project A Project B Difference Project A Project B | 3 | | A | B | A-B | C | Axc | Bxc | 0 $ (12.60) $ (12.60) $ 1.000 $(12.60) $ (12.60) 1 $ 15.12 $ 2.2389 $ 12.88 0.889 $ 13.44 $ 1.99 2 $ - $ 2.2389 $ (2.24) 0.790 $ - $ 1.77 7 3 $ - $ 2.2389 $ (2.24) 0.702 $ - $ 1.57 4 $ - $ 2.2389 $ (2.24) 0.624 $ - $ 1.40 9 5 $ - $ 2.2389 $ (2.24) 0.555 $ - $ 1.24 6 $ - $ 2.2389 $ (2.24) 0.493 $ - $ 1.10 $ 2.2389 $ (2.24) 0.438 $ - $ 0.98 $ 2.2389 $ (2.24) 0.390 $ - $ 0.87 13 9 $ - $ 2.2389 $ (2.24) 0.346 $ - $ 0.78 14 10 $ - $ 2.2389 $ (2.24) 0.308 $ - $ 0.69 15 11 $ - $ 2.2389 $ (2.24) 0.274 $ - $ 0.61 16 12 $ - $ 2.2389 $ (2.24) 0.243 $ - $ 0.54 17 13 $ - $ 2.2389 $ (2.24) 0.216 $ - $ 0.48 14 $ - $ 2.2389 $ (2.24) 0.192 $ - $ 0.43 15 $ $ 2.2389 $ (2.24) 0.171 $ . $ 0.38 20 16 $ $ 2.2389 $ (2.24) 0.152 $ - $ 0.34 21 17 $ - $ 2.2389 $ (2.24) 0.135 $ - $ 0.30 18 $ - $ 2.2389 $ (2.24) 0.120 $ - $ 0.27 23 19 $ - $ 2.2389 $ (2.24)| 0.107 $ - $ 0.24 24 20 $ - $ 2.2389 $ (2.24) 0.095 $ - $ 0.21 25 26 IRR 20.00%! 17.00% 16.41% NPV = $ 0.84 $ 3.61 27 (Crossover rate)

b) NPV-A NPV-B Select both Plan A and Plan B Yes Yes 0.00% $ 5.00% $ 10.00% $ 12.00% $ 15.00% $ 17.00% $ 20.00% $ 2.52 $ 32.18 1.80 $ 15.30 1.15 $ 6.46 0.90 $ 4.12 0.55 $ 39.44 9.15 $ 38.81 - $1.701

*Please rate thumbs up