Spreadsheet Assignment Alternative methods of depreciation
Short Company purchased a computer on January 1, 2011, 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:
2011 | 2,500 hours |
2012 | 2,400 hours |
2013 | 2,000 hours |
2014 | 1,700 hours |
2015 | 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:
Beginning | Ending | ||||||
Year |
Cost | Accumulated | Book | Depreciation |
Cost | Accumulated | Book |
Depreciation | Value | Expense | Depreciation | Value | |||
b. Prepare another five-year depreciation schedule for the computer using the units-of-produetion 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 2011, enter subsequent dates automatically. Position the mouse in the lower right- hand corner of the highlighted cell "2011" until a thin cross appears. Click and drag down four additional rows.
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.