Complete the following scenario using each of the 4 methods of depreciation we've learned. Present each in a spreadsheet

[answerhappygod]

Complete the following scenario using each of the 4 methods of depreciation we've learned.
Present each in a spreadsheet and in TABLE form.
Bubba's Brake Shop
Bubba is buying a Brake repair machine for $20,000. He estimates the machine will have a 4 year useful life after which it will be scrapped for $2,000. The manufacturer of the machine warrants that the machine can do 5,000 brake jobs. Bubba estimates he will do 1,000 brake jobs the first year, 1,400 the second year, 1,600 the third year, and 1,000 the fourth year.