Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

IN EXCEL can you show how it works in excel? Timing Differences The Ewert Exploration Company is considering two mutually exclusive plans for extracting oil

image text in transcribed

IN EXCEL

can you show how it works in excel?

Timing Differences The Ewert Exploration Company is considering two mutually exclusive plans for extracting oil on property for which it has mineral rights. Both plans call for the expenditure of $10.5 million to drill development wells. Under Plan A, all the oil will be extracted in 1 year, producing a cash flow at t = 1 of $13.5 million; under Plan B, cash flows will be $2 million per year for 20 years. a. What are the annual incremental cash flows that will be available to Ewert Exploration if it undertakes Plan B rather than Plan A? (Hint: Subtract Plan A's flows from B's.) Enter your answers in millions. For example, an answer of $1.23 million should be entered as 1.23, not 1,230,000. Round your answers to two decimal places. Use a minus sign to enter cash outflows, if any. Year Incremental Cash Flow (B - A) 1 $ million 2-20 $ million b. If the company accepts Plan A and then invests the extra cash generated at the end of Year 1, what rate of return (reinvestment rate) would cause the cash flows from reinvestment to equal the cash flows from Plan B? Round your answer to two decimal places. % c. Suppose a firm's cost of capital is 10%. Is it logical to assume that the firm would take on all available independent projects (of average risk) with returns greater than 10%? Further, if all available projects with returns greater than 10% have been taken, would this mean that cash flows from past investments would have an opportunity cost of only 10% because all the firm could do with these cash flows would be to replace money that has a cost of 10%? Finally, does this imply that the cost of capital is the correct rate to assume for the reinvestment of a project's cash flows? I. No, the firm would not take on all available independent projects with greater than 10% returns. If taken, risk remains the same among projects and the cost of capital does not vary with the amount of capital raised. II. Yes, the firm would take on all available independent projects with greater than 10% returns. If taken, risk varies with projects and the cost of capital varies with the amount of capital raised. III. Yes, the firm would take on all available independent projects with greater than 10% returns. If taken, risk remains the same among projects and the cost of capital does not vary with the amount of capital raised. -Select- d. Select the correct graph for NPV profiles for Plans A and B

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial management theory and practice

Authors: Eugene F. Brigham and Michael C. Ehrhardt

12th Edition

978-0030243998, 30243998, 324422695, 978-0324422696

More Books

Students also viewed these Finance questions

Question

2. Avoid controlling language, should, must, have to.

Answered: 1 week ago

Question

How does selection differ from recruitment ?

Answered: 1 week ago