EXCEL MASTER IT$!$ PROBLEM $($for MBA Accounting course$)$

PLEASE COMPLETE IN EXCEL.. easy$-$to$-$follow steps would be greatly appreciated! :$)$

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

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

c$.$ What is the NPV of the project?

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

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