A profitable company making earthmoving equip- ment is considering an investment of $150,000 on equipment that will have a 5-year useful life and a $50,000 salvage value. Use a spreadsheet function to compute the MACRS depreciation schedule. Show the total depreciation taken (=sum ()) as well as the PW of the depreciation charges discounted at the MARR%. If money is worth 10%m which one of the following three methods of depreciation would be preferable? Required:
a. Straight line method
b. Double declining balance method.
c. MACRS method.