From book: Engineering Economy

From book: Engineering Economy by Ted Eschenbach

5- Problem12.14- A conveyor was purchased for $40,000. Shipping and installation costs were $15,000. It was expected to last 6 years, when it would be sold for $5000 after paying $3000 for dismantling.

Instead,it lasted 9 years, and several workers were permitted to take it apart on their own time for reassembly at a private technical school. How much of again, loss, or recaptured depreciation is there? Assume:

(a)7-yearMACRS.

(b)Straight-line.

(c)Double-declining balance with switch to straight-line.

(d)SOYD

please complete in an Excel doc, thank you!