In: Accounting
University Car Wash built a deluxe car wash across the street
from campus. The new machines cost $261,000 including installation.
The company estimates that the equipment will have a residual value
of $27,000. University Car Wash also estimates it will use the
machine for six years or about 12,000 total hours. Actual use per
year was as follows:
Year | Hours Used |
1 | 2,800 |
2 | 1,400 |
3 | 1,500 |
4 | 2,500 |
5 | 2,300 |
6 | 1,500 |
Required: 1. Prepare a depreciation schedule for six
years using the straight-line method. (Do not round your
intermediate calculations.) 2. Prepare a depreciation schedule for six
years using the double-declining-balance method. (Do not
round your intermediate calculations.) 3. Prepare a depreciation schedule for six
years using the activity-based method. (Round your
"Depreciation Rate" to 2 decimal places and use this amount in all
subsequent calculations.) |
1.
Straight line Method | |
Cost of Machine | $ 261,000 |
Less: salvage value | $ 27,000 |
Depreciable value | $ 234,000 |
Depreciation ($234,000 / 6) | $ 39,000 |
Depreciation expense for per year | $ 39,000 |
Year | Depreciation expense | Accumulated depreciation | Net book value |
1 | $ 39,000 | $ 39,000 | $ 222,000 |
2 | $ 39,000 | $ 78,000 | $ 183,000 |
3 | $ 39,000 | $ 117,000 | $ 144,000 |
4 | $ 39,000 | $ 156,000 | $ 105,000 |
5 | $ 39,000 | $ 195,000 | $ 66,000 |
6 | $ 39,000 | $ 234,000 | $ 27,000 |
2.
Depreciation under DDB Method | ||||
Year - a | Net Book value, beginning of year - b | Double declained depreciation - c = b/Life of assets*2 | Accumulated depreciation | Net book value, End of the year - d = b-c |
Year 1 | $ 261,000 | $ 87,000 | $ 87,000 | $ 174,000 |
Year 2 | $ 174,000 | $ 58,000 | $ 145,000 | $ 116,000 |
Year 3 | $ 116,000 | $ 38,667 | $ 183,667 | $ 77,333 |
Year 4 | $ 77,333 | $ 25,778 | $ 209,444 | $ 51,556 |
Year 5 | $ 51,556 | $ 17,185 | $ 226,630 | $ 34,370 |
Year 6 | $ 51,556 | $ 24,556 | $ 251,185 | $ 27,000 |
3.
Depreciation under Activity based Method | ||||
Year - a | Depreciable value ($261,000-$27,000) | Number of hours used - c | Depreciation expense - d = b/12,000*c | Accumulated depreciation |
Year 1 | $ 234,000 | 2,800 | $ 54,600 | $ 54,600 |
Year 2 | $ 234,000 | 1,400 | $ 27,300 | $ 81,900 |
Year 3 | $ 234,000 | $ 1,500 | $ 29,250 | $ 111,150 |
Year 4 | $ 234,000 | $ 2,500 | $ 48,750 | $ 159,900 |
Year 5 | $ 234,000 | $ 2,300 | $ 44,850 | $ 204,750 |
Year 6 | $ 234,000 | $ 1,500 | $ 29,250 | $ 234,000 |
You can reach me over comment box if you have any doubts. Please rate this answer