I need excel working along with calculations and formulas. I have the answers but need the step by step guide.

Answers

11-5:

a) Straight Line: $425,000 per year

MACRS: $566,610; $755,650; $251,770, $125,970

b) MACRS, $27,043.62 higher

11-6:

a) -$1,118,000

b) $375,612; $418,521; $304,148

c) $437,343

d) NPV = $78,790 - Purchase

11-7:

a) -$89,000

b) $26,332; $30,113; $20,035

c) $24.519

d) NPV = -$6700 - Don't purchase