Short Company purchased a computer on January 1, 2013, for $5,000. An additional $100 was paid for delivery charges. The computer was estimated to have a life of five years or 10,000 hours. Salvage value was estimated at $300. During the five years, the computer was used as follows:

2013 ........2,500 hours

2014 ........2,400 hours

2015 ........2,000 hours

2016 ........1,700 hours

2017 ........1,400 hours

Required

a. Prepare a five-year depreciation schedule for the computer using the straight-line depreciation method. Be sure to use formulas for all computations including depreciation expense. Set up the following headings for your schedule:

b. Prepare another five-year depreciation schedule for the computer using the units-of-production method. Use (copy) the headings used in Requirement a.
c. Prepare another five-year depreciation schedule for the computer using the double-declining-balance method. Use (copy) the headings used in Requirement a.
d. Prepare another five-year depreciation schedule for the computer using the MACRS method. Use (copy) the headings used in Requirement a.
Spreadsheet Tip
After the year 2013, enter subsequent dates automatically. Position the mouse in the lower right hand corner of the highlighted cell “2013” until a thin cross appears. Click and drag down four additionalrows.

Transcribed Image Text:

Beginning Ending Accumulated Book Year Cost Depreciation Value Expense Cost Depreciation Value Accumulated Book Depreciation