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:
.png)
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 additional rows.