Question

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.


$1.99
Sales0
Views108
Comments0
  • CreatedOctober 26, 2013
  • Files Included
Post your question
5000