Question

In: Finance

A company is considering two mutually exclusive expansion plans. Plan A requires a $39 million expenditure...

A company is considering two mutually exclusive expansion plans. Plan A requires a $39 million expenditure on a large-scale integrated plant that would provide expected cash flows of $6.23 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 9%.

a.) A company is considering two mutually exclusive expansion plans. Plan A requires a $39 million expenditure on a large-scale integrated plant that would provide expected cash flows of $6.23 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 9%.

Plan A:

Plan B:

b.) By graphing the NPV profiles for Plan A and Plan B, determine the crossover rate. Round your answer to one decimal place.

c.) Calculate the crossover rate where the two projects' NPVs are equal. Round your answer to one decimal place.

d.) Is NPV better than IRR for making capital budgeting decisions that add to shareholder value?

Solutions

Expert Solution

The time horizon of both the projects is the same. Thus, by using normal NPV and IRR formula we can select which project to choose.

a)

The formula for NPV is

Now, we will use the excel formula to calculate the NPV

The cash flow and NPV of Project A and B is as follows

Thus

NPV of firm A = 16.40

NPV of firm B =11.52

b)

To draw NPV profile first we need to calculate NPV from above cash flows at various discount rates as follows

The NPV profile is as follows

c)

To calculate the crossover rate we need to calculate the difference in cash flows of both the projects and then calculate the IRR of those cash flows. This IRR is the crossover rate of both the cash flows

A-B
-27
3.54
3.54
3.54
3.54
3.54
3.54
3.54
3.54
3.54
3.54
3.54
3.54
3.54
3.54
3.54
3.54
3.54
3.54
3.54
3.54
11.67%

The IRR = 11.67%

Hence, the crossover rate is 11.67%

d)

NPV is always better than IRR in selecting mutually exclusive projects. One reason is that IRR assumes that the cash flow is reinvested at IRR. This is a problematic assumption because there is no guarantee that such opportunities will be available in future. Whereas, NPV assumes that the cash-flows will be reinvested at Cost of capital which is a realistic and practical assumption. Hence, NPV is better than IRR


Related Solutions

A company is considering two mutually exclusive expansion plans. Plan A requires a $39 million expenditure...
A company is considering two mutually exclusive expansion plans. Plan A requires a $39 million expenditure on a large-scale integrated plant that would provide expected cash flows of $6.23 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 10%. The data has been collected in the Microsoft Excel Online file...
A company is considering two mutually exclusive expansion plans. Plan A requires a $39 million expenditure...
A company is considering two mutually exclusive expansion plans. Plan A requires a $39 million expenditure on a large-scale integrated plant that would provide expected cash flows of $6.23 million per year for 20 years. Plan B requires a $13 million expenditure to build a somewhat less efficient, more labor-intensive plant with an expected cash flow of $2.91 million per year for 20 years. The firm's WACC is 10%. The data has been collected in the Microsoft Excel Online file...
A company is considering two mutually exclusive expansion plans. Plan A requires a $39 million expenditure...
A company is considering two mutually exclusive expansion plans. Plan A requires a $39 million expenditure on a large-scale integrated plant that would provide expected cash flows of $6.23 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 9%. Calculate each project's NPV. Round your answers to two decimal places....
A company is considering two mutually exclusive expansion plans. Plan A requires a $39 million expenditure...
A company is considering two mutually exclusive expansion plans. Plan A requires a $39 million expenditure on a large-scale integrated plant that would provide expected cash flows of $6.23 million per year for 20 years. Plan B requires a $11 million expenditure to build a somewhat less efficient, more labor-intensive plant with an expected cash flow of $2.47 million per year for 20 years. The firm's WACC is 11%. Calculate each project's NPV. Enter your answers in millions. For example,...
A company is considering two mutually exclusive expansion plans. Plan A requires a $39 million expenditure...
A company is considering two mutually exclusive expansion plans. Plan A requires a $39 million expenditure on a large-scale integrated plant that would provide expected cash flows of $6.23 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 10%. Calculate each project's NPV. Enter your answers in millions. For example,...
A company is considering two mutually exclusive expansion plans. Plan A requires a $39 million expenditure...
A company is considering two mutually exclusive expansion plans. Plan A requires a $39 million expenditure on a large-scale integrated plant that would provide expected cash flows of $6.23 million per year for 20 years. Plan B requires a $13 million expenditure to build a somewhat less efficient, more labor-intensive plant with an expected cash flow of $2.91 million per year for 20 years. The firm's WACC is 9%. The data has been collected in the Microsoft Excel Online file...
A company is considering two mutually exclusive expansion plans. Plan A requires a $39 million expenditure...
A company is considering two mutually exclusive expansion plans. Plan A requires a $39 million expenditure on a large-scale integrated plant that would provide expected cash flows of $6.23 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...
A company is considering two mutually exclusive expansion plans. Plan A requires a $41 million expenditure...
A company is considering two mutually exclusive expansion plans. Plan A requires a $41 million expenditure on a large-scale integrated plant that would provide expected cash flows of $6.55 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...
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 $13 million expenditure to build a somewhat less efficient, more labor-intensive plant with an expected cash flow of $2.91 million per year for 20 years. The firm's WACC is 11%. Calculate each project's NPV. Enter your answers in millions. For example,...
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 $11 million expenditure to build a somewhat less efficient, more labor-intensive plant with an expected cash flow of $2.47 million per year for 20 years. The firm's WACC is 11%. a. Calculate each project's NPV. Round your answers to two decimal...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT