Please solve a$-$d using Excel!

Information Excel Master It$!$ Problems

For this Master It$!$ assignment, refer to the Goodweek Tires, Inc., case at the end

of this chapter. For your convenience, we have entered the relevant values such as

the price and variable costs in the case on the next page. For this project, answer

the following questions:

EXCEL MASTER

coverage online

a$.$ What is the profitability index of the project?

b$.$ What is the IRR of the project?

c$.$ At what OEM price would Goodweek Tires be indifferent to accepting the project? Assume the replacement market price is constant.

d$.$ At what level of variable costs per unit would Goodweek Tires be indifferent to accepting the project?is in image

Excel Master It$!$ Problems

For this Master It$!$ assignment, refer to the Goodweek Tires, Inc., case at the end

of this chapter. For your convenience, we have entered the relevant values such as

the price and variable costs in the case on the next page. For this project, answer

the following questions:

EXCEL MASTER

coverage online

a$.$ What is the profitability index of the project?

b$.$ What is the IRR of the project?

c$.$ At what OEM price would Goodweek Tires be indifferent to accepting the project? Assume the replacement market price is constant.

d$.$ At what level of variable costs per unit would Goodweek Tires be indifferent to accepting the project?